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.
N6517DSlaboszewski Donald W Jr · Joliet, ILN6517JSwaz Aviation LLC · Mesa, AZN6517PJames Dennis · Pleasant Grove, CAN6517UNova Accounting LLC · Herndon, VAN65180Mccraw Bryan · Telephone, TXN6518PRubscha Rick L · Peoria, AZN6518UWhetzel Peter W · Mathias, WVN6518WWedmore Catherine A · Wellington, FLN6518YKiley Clement · Plainville, MAN6518ZSimmons Aviation Services LLC · Pawcatuck, CTN65191Bampton Dennis · Portage Des Sioux, MON65192Tactical Integrated Training Solutions LLC · Colorado Springs, CON65194Vliegen LLC · Urbandale, IAN65195Sciortino Warren A III · Crested Butte, CON65197Aviator Education LLC · Greeley, CON6519JDms Defense LLC · Annapolis, MDN6519RC & C Aeroventures LLC · Carson City, NVN6519TVeverka Merle G · Frederick, CON6519USherr Steven · Mandan, NDN6519WFalcon Aircraft Services Inc · Rockford, ILN651DMAircraft Guaranty Corp Trustee · Oklahoma City, OKN651ECEagle Sky Patrol Inc · Deadwood, SDN651EDFlying Colors Airpants Inc · Leesburg, FLN651FLGillam Charlene · Akron, OHN651FTSt Louis Flight Training LLC · Cahokia, ILN651KCPacific Flight Aviation LLC · Costa Mesa, CAN651LMMeinhardt J Karl · North Fort Myers, FLN651MAPea-Wayman Flight LLC · Daytona Beach, FLN651RMackey Aviation LLC · Talking Rock, GAN651RASimply Living LLC · Fort Myers, FLN651RBBrown Russell D · Lebanon, TNN651RKChristensen Nathan · Newnan, GAN651RVKiloh James W · Cypress, TXN651TSGoodfellow David · Sutherland, VAN6520CVail Communications Inc · Orangevale, CAN6520PMoffett Jules M DBA · Elmore, ALN6520ULundquist Justin Carl · Sarasota, FLN6520WP T Arts LLC · Grand Rapids, MIN6520ZWolter Randall R · Frederick, SDN652171434 Jpl LLC · Wilmington, DEN6521DWaade Odd · Bellingham, WAN6521LRegistered aircraftN6521WEgert James R · Piedmont, OKN6522Uaa International Inc · La Verne, CAN65221Wings Over Texas Holdings LLC · Denton, TXN65225Leon Manuel Perez · Lake Worth, FLN6522JAbbott Aircraft Sales And Service LLC · Jefferson City, MON6522RKnot Ventures LLC · Kalispell, MTN6522UWilliamson Truman Dorman · Terrell, TXN6522WLopienski Stephen · Selkirk, NY
Back to AD 87-10-06 R1