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.
N8261HOxford Flying Club Inc · Oxford, CTN8261PWarzek Mary Ann · Halfmoon, NYN8261SHoffmann David M · Mauston, WIN8261YWilliams Brannon R · Fort Worth, TXN82629Dgf & Associates Inc · Irving, TXN8262ASnider Jay T · Grove City, OHN8262ESee Robert W · Catawba, NCN8262HRegistration Pending · Bucyrus, OHRegistration pendingN8262JHarris James D · Lasalle, CON8262KHesston College · Hesston, KSN8262N40 Flight LLC · Fernandina Beach, FLN8262SWisconsin Aviation - Four Lakes Inc · Madison, WIN8262UHorton Air Ventures LLC · Eustis, FLN8262WCalhoun Jerry H · Washington, NCN8262YAchamp LLC · Memphis, TNN82635Chase 13 LLC · Wilmington, DEN8263JIsaacs David R · Fort Wayne, INN8263NPiper Partners Mbda LLC · Fairfield, ILN8263WViking Crown LLC · Prescott, AZN82644Chandler Elijah J S · Pilot Mountain, NCN8264FRick Aviation Inc · Newport News, VAN8264JCouch James L · Cochran, GAN8264NRegistered aircraftRegistration pendingN8264VRuby Jeffrey Steven · Sharon, SCN8264WEyrich Richard L · Cave Creek, AZN8264YPatterson Casey Paul · Kinston, ALN8265CDelgado Francisco Trustee · Carmel, INN8265GYencarelli Mark S · Riverview, FLN8265HSlinger LLC · Laramie, WYN8265JConley Donald · Claude, TXN8265NImmanuel Baptist Church Of Kansas City Kansas · Basehor, KSN8265WRoy Kristi D · Burleson, TXN82665Schiestle Jason T · Greenville, PAN82667Corfman Randle S · Lino Lakes, MNN82669Balcomb Mark S · Silt, CON8266CPiper 8266c LLC · Indianapolis, INN8266EPropel Air LLC · Pottstown, PAN8266GBode Todd D · Brush Prairie, WAN8266JSumrall Olen · Tylertown, MSN8266WCraddock James E · Greensboro, NCN8266YWerner Thomas E · Newark, DEN82671Keleman Kenneth S · Bellingham, WAN82676Accelerated Aviation Instruction LLC · Owatonna, MNN8267CMichie Robert B · Austin, TXN8267EFlippin Steven P · Oak Ridge, NCN8267NGallup Asa N · Morgan, TXN8267YMh Aviation Inc · Lancaster, CAN82682Long Jory J · Lake Ozark, MON8268BMarinko Christopher M · Geneva, OHN8268CJk Aviation LLC · Austin, TX
Back to AD 90-04-06 R1