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.
N915MBBarras David G · Breaux Bridge, LAN915PSmith Jr Franklin R · Rock Hill, SCN915PABird Acquisition LLC · Phoenix, AZN915PBLease Lawrence · Royal Oaks, CAN915PRAvialogia Inc · CancunN915RDDavis Richard L · Kenai, AKN915RSHayward Houston C · Lansdale, PAN915RVWiegand Jeffrey L · Ocean Isle Beach, NCN915TAAurora Aircraft LLC · Waterford, MIN915TTLake Elmo Aero LLC · Lake Elmo, MNN915WBBordelon Warren P · Breaux Bridge, LAN915WCBarr Air Patrol LLC · Mesquite, TXN915WMChambers David N · Cullman, ALN915WVSmith Aviation LLC · Springer, OKN916Kyer Barry Patrick · Honey Grove, TXN9160DMalsby Thomas H · Blairsville, GAN9160HTodd Media Inc · Tuscaloosa, ALN9160JMohan Aditya · Rancho Cordova, CAN9160NBoeing Co · Renton, WAN9160PHeath Allen W · Westlake, TXN9160VLangis Maximus · Newburyport, MAN9160WAmerican Aviator LLC · Arlington, TXN9160ZBriggs Robert B · Germantown, TNN9161DSchlesinger Warren · Page, AZN9161EKurtz Andrew · Boise, IDN9161FHuie John E · Burnet, TXN9161HAir Athens LLC · Athens, GAN9161JNortheast Nebraska Aviators Inc · Wayne, NEN9161KSkymook Aviation LLC · Beaver Falls, PAN9161NCorvallis Rapid Transit LLC · Corvallis, ORN9161PAven Michael D · Georgetown, INN9161SCarr Jack Willson · East Lansing, MIN9161UHeron Kyle B · Modesto, CAN9161VKaroki Jonah · Strasburg, CON9161YFonville David N · Cresson, TXN91622Utterback Karl D · Fort Wayne, INN9162DWeagle Aviation LLC · Birmingham, ALN9162HStratus Aviation LLC DBA · Vacaville, CAN9162JHillelson Lawrence E · Grosse Ile, MIN9162NMann Aviation LLC · Wilmington, DEN9162PBrown Nathan B · Wallace, KSN9162WYanka Anthony Joseph · Moorestown, NJN91631Seale Taylor Edward · Madison, WIN91634Tharp Anthony W · Charleston, WVN9163CZaparovanny Alexey · Westford, MAN9163DRubbert Jan Dale · Upham, NDN9163JCavu Flight Training LLC · Freeport, MEN9163PMiller Richard Marc Trustee · Dana Point, CAN9163QWebb John L · Elgin, TXN9163WMetsker Kay B · Winnemucca, NV
Back to AD 87-10-06 R1