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.
N720SUOklahoma State University · Stillwater, OKN720TSSpencer David T · Dayton, OHN720UOhio University · Albany, OHN720WDThorntons Aircraft LLC · Tuscaloosa, ALN7210DRainey Lee S · Troy, MON7210FCedar Yopanz Flying Club LLC · Las Vegas, NVN7210GOgle Howard J · Moorpark, CAN7210HMenzie Bradley J · Sublette, KSFirst renewal noticeN7210JBoling Kenneth A · Greenbrier, ARN7210PBirdwell David W · Richmond, TXN7210QAthol Orange Aero Club Inc · Athol, MAN7210WN7210w Corp · Selma, NCN7211DThacker William E · Chenoa, ILN7211JGolden Arrow Transportation · Plainfield, NJN7211LMoes Crop Dusting Service Inc · Marysville, CAN7211PWhite Jordan H · Gold Beach, ORN7211RDavis Michael D · Danville, VAN7211YBeers Jason · Girard, OHN7211ZLas Vegas Valley Soaring Association · Jean, NVN7212FDe Valle Rafael · Columbus, GAN7212GMeister James A · Star Prairie, WIN7212JF7 Aviation LLC · Kalispell, MTN7212QLink Air Service LLC · Minong, WIN7212VAir Dakota Flite Inc · Hettinger, NDN7212WFerki Joseph J · Franklin, VAN7213DFranklin Gary B · Willcox, AZN7213LHorne Jared I · Opelika, ALN7213QChain O Lakes Flying Club & Co Inc · Waupaca, WIN7213WSmith Scott V · Presque Isle, MEN7214EZachrison Marty · Spring Hill, FLN7214JFalcon Flyers LLC · Hamilton, MTN7214PKilmer Robert · Valentine, NEN72159Geiger William G · New Castle, KYN7215DSchmidt Wilfred L III · Elgin, ILN7215FGailie Thomas E · Middletown, NYN7215QRhynette Airways LLC · Key Largo, FLN7216FBravo Aviation Assets LLC · Akron, OHN7216GLincoln Skyways Inc · Lincoln, CAN7216JCaden Aviation Services LLC · Dallas, TXN7216PFerrara Antonio · Granbury, TXN7216QElias Close Deanna · Kenilworth, ILN7216WBim Merle Robert W III · Piqua, OHN7216YMerriwether David E · Whitesburg, GAN7217FWheeler Samuel C · O Fallon, MON7217GOne Niner Right LLC · Berkeley, CAN7217JAvionraton LLC · Valparaiso, INN7217PNewman Samuel M · Taylorsville, UTN7217QRegistration Pending · Fond Du Lac, WIRegistration pendingN7218DDuvall Brian G · Palmer, AKN7218JSullivan Michael D · Braddyville, IA
Back to AD 87-10-06 R1