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.
N5908QT&T Aviation LLC · Clarksville, TNN5908UEcostudio Real Estate LLC · South Amboy, NJN5908WPrindle Ry · Hillsboro, ORN5909EOwens Flight Training LLC · Lafayette, LAN5909HDelaney John D · Mineral Point, WIN5909WCornebise Ricky · Levelland, TXN590DCDonald Pohland J · Anchorage, AKN590FLDonnelly Matthew J · Romulus, NYN590NDChristiansen Aviation LLC · Wilmington, DEN590RUSA Jet And Helicopter Inc · Denver, NCN590SProspect Ridge Aviaton Inc · Morganton, NCN590SCGarcia Daniel J · Chino Hills, CAN590SPTubreaux Aviation Services LLC · Shreveport, LAN5910DEastin Toby M · Jefferson City, MON5910HKlann Jason · Yorkville, ILN5910WMetz Tyler B · Bridgeport, WVN5910ZBishop David E · Butlerville, INN5911LSkyborne Airline Academy Inc · Vero Beach, FLN5911QFuller Christopher · Ottsville, PAN5911UMoore Air Inc · Honolulu, HIN5911WBrimmer Harold C · Longview, TXN5911ZDavis Jim F · Poteau, OKN59121Hickey Aero Services LLC · White Hills, AZN5912DRenner David L · Ferndale, CAFirst renewal noticeN5912QWilson Paul M · Bonifay, FLN5913Skyhaven Airport Inc · Tunkhannock, PAN5913DCaldwell Caleb Z · Anchorage, AKN5913HMesserla David M · Manhattan, KSN5913SStoican Steve Gene · Ryegate, MTN5913XHay Johnny L · Bethel, OHN5914HFambrough Todd W · Ocala, FLN5914UShawver Aviation LLC · Knoxville, IAN5914VLuvsflying Flight Training LLC · Staten Island, NYN5914WSteadfast Avatiion LLC · Mesa, AZN5914XTamvakis Dimitri · Orlando, FLN5915DMason Jack A · Reidsville, NCN5915QHaslem Patrick S · Dimondale, MIN5915UOsorio Aviation Corp · Miami, FLNon-citizen corporation, flight hours not reportedN5915WTheobald Daryl · Aberdeen, SDN5916HHainline James L · Klamath Falls, ORN5916JUnited States Air Force - Owner · Eglin Afb, FLN5916QSeidel Daniel F · Los Altos Hills, CAN5916UForsman Airways LLC · Glenwood, MNN5917LHill Jeffrey A · Boise, IDN5917VHeyano Norman J · Dillingham, AKN5917WHiggins James L · Harrisville, MIN5917ZKoch Christopher P · Batavia, NYN5918HHarvey Michael V · Port Leyden, NYN5918JStansfield Carl B · Springdale, UTN5918LRobello Mel K · San Jose, CAFirst renewal notice
Back to AD 90-04-06 R1