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.
N9220PDavid Rever Aviation LLC · Dewey Beach, DEN9220SWard Jessica · Southport, NCN9221DOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLN9221JJgms Rose LLC · Stamford, CTN9221PStevenson Tom · Portland, ORN9221WWadi-Ramahi Shadi J · Evansville, INN9222DMatthews David C · Fairbanks, AKN9222PAztec Remains LLC · Potosi, WIN9222QGood Shepherd Leasing Corp · Brooksville, FLN9222RWellman A Ryan · San Jose, CAN9222SSvendsen James · Center Moriches, NYN9222VSoco Scuba LLC · Austin, TXN9222WJohnson Michael E · Tyler, TXN92236Garfoot William K · Verona, WIN92239Kingdom Air LLC · Kalispell, MTN9223FMckeeman Kevin · Abilene, KSN9223HHallock Robert C III · Sag Harbor, NYN9223JRudo Mark R · Milton, DEN9223VQuick Janice L · Wrightwood, CAN9223WPierce Construction LLC · Shelby, ALN92247World Class Aviation Ltd · Bellefontaine, OHN9224DAlleman Mark J Inc · Wilmington, DEN9224JJackson Jonathan · Siloam Springs, ARN9224NBlanchard Aviation LLC · Nazareth, PAN9224PAnde Leasing Co LLC · Edgewood, NMN9224VBevington Carl R · Middle Point, OHN9224WOppermann K Edward · Kingwood, TXN9224YFavret Bernard A · Ocean Springs, MSN92255Kloker Daniel E · Owasso, OKN9225CMeriden Aviation Center LLC · Meriden, CTN9225MSmith Carl L · Danville, KYN9225NOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLFirst renewal noticeN9225PRegistered aircraftN9225VDuncan Mark E · Marlton, NJN9225WMosley Marvin C · Buckley, WAN9225YDodson International Parts Inc · Rantoul, KSN9226CLane Community College · Eugene, ORN9226DClf Industries LLC · Thornton, CON9226FLewis University · Romeoville, ILN9226HDebt LLC · Yuma, AZN9226KAlatis Nicholas C · Cincinnati, OHN9226NGods Country Aircraft LLC · Trapper Creek, AKN9226SSpencer Montgomery L · Clinton, SCN9227JBinns George E · Hackettstown, NJN9227MMullis Brent S · Garfield, GAN9227PSiebold Peter · Tehachapi, CAN9227WMasterman Robert David · Chugiak, AKN9228DLavender James R · Gainesville, TXN9228JHail State Aviation LLC · Madison, MSN9228LRegistered aircraft
Back to AD 87-10-06 R1