AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-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:90-04-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:90-04-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:90-04-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.
N4095PTorell Pamela O · Port Saint Lucie, FLN4095ZBreidenbach Bros Inc · Iliff, CON40963Grant Matthew D · Alvord, TXN40965Portsmouth Flying Club LLC · Epsom, NHN40966Skytech Hc Ltd · Fredericksburg, OHN40967Mcbroom Darrin · Des Moines, IAN4096ESwiss John T · Anchorage, AKN4096GWilbur-Ellis Co · Salinas, CAN4096XFoster Robert L Jr · Chandler, OKN4096ZTurner Hal Eugene Jr · Tiburon, CAN4097Puhlmann Otto B · Logan, UTN40972Terry Aaron D · Glendale, AZN4097GTriple F Flying Inc · Benton, PAN4097MN4097m LLC · Boynton Beach, FLN4097PBarr Air Patrol LLC · Mesquite, TXN4097XWilson Dane A · Church Point, LAN4097ZSullivan Daniel J · Long Lake, MNN40982Seneca Aviation LLC · Wheaton, MDN40984Four Zero Niner LLC · Granger, IAN40986Air America Inc · Stow, MAFirst renewal noticeN40987Besl Thomas J · Cincinnati, OHN4098FN4098f LLC · Ypsilanti, MIN4098XOstgard William R · Mims, FLN4098ZChant J Archie · Riverton, WYN40993Premier Capital Enterprises LLC · Hurricane, UTN4099EReel Chad · Wasilla, AKN4099NS O Witt And Associates LLC · Ridgecrest, CAN4099XMiller Aviation Group LLC · Coon Rapids, MNN4099ZMayes Brett R · Williams, CAN409AFThomas Douglas M Jr · Blue Bell, PAN409CACoast Flight Training And Management Inc · Dallas, TXN409CCPappy Air LLC · Pickerington, OHN409DParagon Flight Training Co · Fort Myers, FLN409ESN409es LLC · Stuart, FLN409FPAamro Aviation Corp · Lake Worth, FLNon-citizen corporation, flight hours not reportedN409HTHelidon Inc · Willmington, DEN409JPPointer Ned A · The Dalles, ORN409MMStormer Isaac E · Curtis, WAN409RWAllred Mike · Thomasville, NCN409SPTzerefos Lambros P · Mathews, VAN409TPParagon Airplane Leasing Co · Fort Myers, FLN409WMKlink John A Jr · Farmington, PAN409XXPope James D · Clarkston, WAN40ACRadecki Louis · Helenville, WIN40AWKlingbeil Mark T · Bottineau, NDN40BXBreton Michael A · Avon Lake, OHN40BYMassengill Brad · Lowell, INN40CBBurnett Chad H · Draper, UTN40CKDcy Aviation Group LLC · Linton, INN40CMKline Timothy L · Elverson, PA
Back to AD 90-04-06 R1