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.
N5344STop Flight Aviation Snh LLC · Savannah, TNN53456Amelia Reid Aviation LLC · San Jose, CAN5345FArcher Air LLC · Traverse City, MIN5345MNew Orleans Aerial Tours & Flight Training LLC · New Orleans, LAN5345WShisler Bill · Missoula, MTN53463Fara Nick · San Anselmo, CAN53466Paulson Chris M · Eatonville, WAN5346DBoldflight LLC · Greenwood, INN5346EOsprey Holding Company LLC · Foley, ALN5346FSo Send I You LLC · Cheyenne, WYN5346KUsaeroflight LLC · Greenville, SCN5346UAverett University · Danville, VAN5346VRegistered aircraftN5347FDeland Aviation LLC · Deland, FLN5347HMonterey Bay Aviation Inc · Watsonville, CAN5347LKing Michael · Durango, CON5348BBowers Curt E · Jennings, LAN5348DSwaz Aviation LLC · Mesa, AZN5348LPn4 Aviation Holdings LLC · Bishop, CAN5348TDavis Samuel T · Malad City, IDN5348VKavon Clinreg LLC · Palm Beach Gardens, FLN5348ZDavis Robert D · Shongaloo, LAN53491Crossbrook LLC · Willoughby, OHN53494Gandarillas Andrew J · Toledo, WAN5349DFisher Randall A · Salem, OHN5349LHart Brad S · Elephant Butte, NMN534APa28 Aircraft LLC · Wilmington, DEN534CACoast Flight Training And Management Inc · San Diego, CAN534DWValiair Ltd Co Trustee · Casper, WYN534EREmbry Riddle Aeronautical University Inc · Prescott, AZN534FLGray Gary G · Kansas City, MON534LU.S. Department Of The Interior · Boise, IDN534MPJones David C · Williston, VTN534WCPrenter Christian E · Hermosa Beach, CAN53507Flight School Of Gwinnett · Lawrenceville, GAN5350KCenterline Aviation LLC · Oklahoma City, OKN5350LN5350l LLC · Statesville, NCFirst renewal noticeN5350MNewsom Bearden And Cobb Inc DBA · Lubbock, TXN5350PChristiansen Aviation LLC · Wilmington, DEN5350ZAgalotis Paul E · San Martin, CAN5351Robinson Herb · Snowflake, AZN5351HHayes Jeffery M · Yatesville, GAN5351LHillsboro Aero Academy LLC · Hillsboro, ORN5351PPointair Aviation Inc · Port Jeff Sta, NYN5351QBarrett Dannie P · Halfway, ORN5351ZGostola Thomas · Fairmount, INN5352DN5352d LLC · Costa Mesa, CAN5352KPea-Wayman Flight LLC · Daytona Beach, FLN5352LStinson Jonathan L · Douglas, GAN5352WRegistration Pending · Newton, ALRegistration pending, pending cancellation
Back to AD 90-04-06 R1