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.
N73381Wings Over Texas Holdings LLC · Denton, TXN73383Ludington Rental LLC · Ludington, MIN73387Bartley Darrell Jr · Somerset, KYN73388Wings Over Texas Holdings LLC · Denton, TXN7338FKyle Aviation Services LLC · North Charleston, SCN7338PPope Kent M · Hayden, IDN7338WEvans Russell Slade · Austin, TXN73391Holdgate Irvin F · Englewood, FLN73395Quick Caleb B · North Newton, KSN73398Wintons Wings LLC · Bardstown, KYN73399Stone Mary A Trustee · Weeki Wachee, FLN7339FLambright Kevin L · Shipshewana, INN733ABKalman Engineering Inc · Pekin, ILN733ADMarshe Aviation LLC · Upland, CAN733AEMackey Aviation LLC · Talking Rock, GAN733AGRick Aviation Inc · Newport News, VAN733AHAltus Aircraft LLC · Taylor, TXN733AJ578 Airplane Leasing Inc · Kissimmee, FLN733AKParker Helicopters Inc · Watsonville, CAN733AMGlendale Community College · Glendale, CAN733ANAtlas Epigrin Aviation LLC · Austin, TXN733AQCrankshaft Aviation LLC · Pine River, MNN733ATAlpha Tango LLC · Lake Village, ARN733AVPdm Aviation LLC · Greencastle, INN733AWKaiser Eric J · Milford, INN733AYFord Eagles Inc · Plymouth, MIN733AZTactical Integrated Training Solutions LLC · San Antonio, TXN733BCPs N733bc LLC · Green Bay, WIN733BDRegistered aircraftN733BEFlying Particles Inc · Livermore, CAN733BGAviator Air Flight School LLC · Grand Prairie, TXN733BKB & R Aircraft LLC · Wadsworth, OHN733BPDavis Keith I · Manchester, TNN733BRAmalong Tim M · Tucson, AZN733BSJulius William C · Julesburg, CON733BTNorthern Air Aviation LLC · Naples, IDN733BZBz Partners Inc · Purcellville, VAN733CASlowinski David · Chippewa Falls, WIN733CBDavis Lisa E · Tucson, AZN733CCFabrie Terry M · Bakersfield, CAN733CEN2893e LLC · Reno, NVN733CMBotson William J · New Smyrna Beach, FLN733CNChristiansen Aviation LLC · Wilmington, DEN733CPWesterly Air LLC · Westerly, RIN733CQGulf Coast Helicopters Inc · Pearland, TXN733CRNixon Kendal H · Miami, FLN733CSFly Aviation Corp · Wilmington, DEN733CUColeman Michael F · Pelham, NHN733CVBas Part Sales LLC · Greeley, CON733CXDon Davis Aviation Inc · Henderson, KY
Back to AD 87-10-06 R1