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.
N738HTRucci Daniel C · Saint Cloud, FLN738HXRick Aviation Inc · Newport News, VAN738JDClover Management Systems Inc · Sanford, FLN738JGSullivan James F · Hamilton, ILN738JJGreat Lakes Aviation Inc · Batavia, NYN738JPHaskins Robert A · Salinas, CAN738JSWings Over Texas Holdings LLC · Denton, TXN738JTNorthwoods Air LLC · Orono, MEN738JULlano Masonry LLC · Lubbock, TXN738JWAllen Stephen R · Ventura, CAN738JXSuperior Flying Services LLC · Superior, WIN738JZRegistration Pending · Washington, UTRegistration pendingN738KAFlying Aces Aero Fleet Inc · Guyton, GAN738KCCarter Flygare Inc · Sacramento, CAN738KFShouling & Philip Enterprise · Lancaster, CAN738KG738 Kilo Golf LLC · Southern Shores, NCN738KJFly Compton Aeronautical Education Foundation · Compton, CAN738KKSpradley Amanda · Greenwood, SCFirst renewal noticeN738KPJupiter Flight Service And Investing LLC · Lithonia, GAN738KQYeomans James S · Harvey Cedars, NJN738KTGetaway Aviation LLC · Spring Lake, MIN738KUBoehmlehner Steven A · Rosholt, SDN738KWAvetrani Jose A · Miami, FLN738LCCruise Flight Academy Inc · Dalton, GAN738LGSchultz Leesa · Mesquite, NVN738LHLh Enterprise LLC · Eads, TNN738LMBlack Bear Aviation LLC · Scottsdale, AZN738LNSidor David R · Palm Desert, CAN738LPPython Financial LLC · Kalispell, MTN738LSKingfisher Assurance LLC · Fort Worth, TXN738LUUrquhart Air LLC · Parker, CON738LVUrban Aviation Services Inc · Paxton, MAN738MCMoore Michael E · Shawnee, KSN738MEN738me LLC · Miami, FLN738MHCurtis Creek Aviation LLC · Kalispell, MTN738MJOptic Air LLC · Sioux Center, IAN738MKObrien Aviation Inc · Port Orange, FLN738MLSouthern Wings Aircraft Sales Ltd · Bethany, OKN738MRNew World Air LLC · Orland Park, ILN738MTJulep Arbor Flying LLC · Salisbury, NCN738MWN738mw LLC · Jupiter, FLN738MZCarrasco Alonzo · Burleson, TXN738NBLele Aviation LLC · Denver, CON738NCAndrosky Mark J · Superior, WIN738NDFood From The Forest LLC · Wilmington, DEN738NGMusson Jeffrey L · Racine, WIN738NHUS Navy Commander Navy Installation Command · Millington, TNN738NKAscutney Air LLC · Claremont, NHN738NMRegistration Pending · Burlington, WIRegistration pendingN738NNAero Aviation LLC · Long Beach, CA
Back to AD 87-10-06 R1