AD 87-10-06 R1
Registered aircraft · 72,010
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N7364WM Star Aviation LLC · Oconto, WIN7365GPray Aviation Inc · Augusta, KSN7365WRobert Jason T · Fernandina Beach, FLN7365XSelectaire LLC · Rcho Sta Marg, CAN7365YLoguidice Anthony · Bethlehem, PAN73660Hancock Brian · Edmond, OKN73662Flores Francisco H · Avondale, AZN7366DMh Aviation Inc · Lancaster, CAN7366FDesantos Rance · Baldwin, NYN7366LBoles Quincy · Panama City, FLN7366PAnthony Craig D · Keller, TXN7366TJones Bruce E · Aurora, COFirst renewal noticeN7366WBatchelder Norman · Newport Beach, CAFirst renewal noticeN7366YShockley Kenlon D · Aurora, CON7366ZAerial Banners North Inc · Pembroke Pines, FLN73671Registered aircraftN7367EGregg Flying Service Inc · Durango, CON7367FDuffys Aircraft Sales And Leasing Inc · Neillsville, WIN7367JWise Dustin A · Fairbanks, AKN7367LRegistered aircraftN7367WRapp Stephen Martin Trustee · Zephyr, TXN7367ZAerial Banners North Inc · Pembroke Pines, FLN73686Falcon Aviation Inc · Farmington Hills, MIN7368FW Tech Consulting Inc · Wilmington, DEN7368JDylan Branch LLC · Tomball, TXN7368LBohman John T · Monona, WIN7368NAka Fun LLC · Jupiter, FLN7368WBurkholder Earl F · Middleburg, PAN7368YHoenmans John P · Roseville, CAN7369JSmith Zachary T · Nokesville, VAN7369LMcdonnel Jack E Jr · Woodsboro, TXN7369PGrier Randall · Owasso, OKN736BABest Aviation LLC · Hoxie, KSN736BKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN736DWGertiser Frank M · Lapeer, MIN736DZDogwood Memorial LLC · Grapevine, TXN736ERButton Duane D · Lone Tree, CON736FHoffmanns Aircraft Services Inc · Loxahatchee, FLN736HFStoklosa Michael · Miami, FLN736JBBrownell Kenneth C · Leverett, MAN736LBSkyraider Aero Club · Spokane, WAN736LFAvitran Inc · Coral Gables, FLN736MJClover Park Technical College · Lakewood, WAN736NDUnd Aerospace Foundation · Grand Forks, NDN736NGCatcu Aviation LLC · Edinburg, TXN736NJCarr Gary A · Rittman, OHN736PAConnection Leasing Co · Dallas, TXN736QUCloudstreet Partnership · Albuquerque, NMN736QXTeets Trent D · West Fargo, NDN736RAWernsman William Adam Trustee · Garnett, KS
Back to AD 87-10-06 R1