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.
N9228MSteubs Mike H · Portland, ORN9228NEncore Jet Management LLC · San Antonio, TXN9228PShillig Vance R · Colorado Springs, CON9228VDuval James A · Lima, OHN9229BSsb Holdings LLC · Lake Wales, FLN9229CNoble Land & Cattle Inc · Albion, NEN9229DStevens Mark F · Ocean Springs, MSN9229FCooke John W III · Carthage, TXN9229JUnterschuetz Phillip David · Ladysmith, WIN9229MMadsen Jan Eric · Lincoln, NEN9229PKoeman Scott B · Fort Moore, GAN9229SRegistered aircraftN9229WShackelford John S Jr · Roanoke, TXN922BSCentral Airlines Inc · Leawood, KSN922CTSweptwing Holdings LLC · Houston, TXN922DDHillsboro Aero Academy LLC · Hillsboro, ORN922EAButler Ronald A · Cumming, GAN922JMApplied Aerospace Concepts Pllc · Bloomington, MNN922KDDoughty Robert M · Earlville, ILN922MJAga Aviation LLC · Woodruff, SCN922PBillester Stephen E M · Parker, CON922TAAtp Aircraft 4 LLC · Wilmington, DEN922TJBowar Gary R · Miranda, SDN92303Herman M Flink Inc · Mount Dora, FLN92306High Wingers Inc · Racine, WIN92307Lowcountry Flight LLC · Johns Island, SCN9230DTbo Enterprises Inc · Chippewa Falls, WIN9230MPernick Kevin · Milford, IAN9230SSlominski Marcus A · Chapin, SCN9230TProctor Richard P · Statesboro, GAN9230VCloud Surfing Aviation LLC · Costa Mesa, CAN9230WLorenti Anthony Charles · Meriden, CTN92318Flitepro Inc · Murrieta, CAN9231AK&L Soaring LLC · Cayuta, NYN9231JLeetz Tom · Elgin, ILN9231PSeaton Flying Services Inc · Salado, TXN9231VShaffer Lawrence · West Des Moines, IAN9231YBbees LLC · Moss Point, MSN92324Pea-Wayman Flight LLC · Daytona Beach, FLN9232BLaird Charles L · Adelanto, CAN9232GHarold H Bruner · Pinehurst, IDN9232JAdirondack Flying Club LLC · Rome, NYN9232RRogers Ricky R · Saint Francis, KSN9232TSannella Joseph J · Missoula, MTN9232VFerri Lawrence E · Lake Worth, FLN9232WBarnum Eric E Trustee · Maumee, OHN9233MSlone Buddie M · Waynesburg, KYN9233PBlandina Leon V · New Hudson, MIN9233RBlash Gregory J · Corona, CAN9233VRenner David C Jr · Belleville, IL
Back to AD 87-10-06 R1