AD 90-06-13
Registered aircraft · 1,827
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-06-13')
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-06-13')
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-06-13') 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-06-13') 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.
N917TLCook Childrens Health Enterprises · Fort Worth, TXN917WAN917wa Corp Trustee · Wilmington, DEN918AJMaciley Av Mgmt LLC · Wilmington, DEN918XDos Hombres Ventures LLC · Wilmington, DEN919HPKing Three LLC · Forest Hill, MDN919REIvy Brothers Aviation LLC · Kilgore, TXN91CVTwin P Aviation LLC · Fort Worth, TXN91MFCkw Aviation LLC · Dalhart, TXN91RWJujufa21 LLC · Wilmington, DEN91VBParker Aviation LLC · Benson, NCN920PTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN9228ZN9928z LLC · Greeley, CON922ACGlenville Aviation LLC · Lake George, NYN922EHWolf Rock Industries Inc · Huntington Beach, CAN922KGGaka LLC · Jal, NMN922KMRosado Aviation Inc · Moosic, PAN922SLStriping Concepts Aviation LLC · Waxhaw, NCN922TXWheeler Trailer Inc · Chicago, ILN923ASDjp Properties LLC · Selma, CAN923JHHarper Excavating Inc · Salt Lake City, UTN924ACDena'Ina Air Taxi LLC · Anchorage, AKN924CBJet Air Inc · Iowa City, IAN926CBSgj Racing LLC · Miami, FLN926CESilverado Aviation LLC · Fort Wayne, INN926NCBb & Ryder LLC · Greenbrier, ARN927PKSymmetry Aviation LLC · Mount Pleasant, TXN928PSPegasus II LLC · Nashville, TNN92SSUS Trinity Equipment LLC · Argyle, TXN933PBApp Concepts LLC · Wichita, KSN936BRMgt Interests LLC · Navasota, TXN938AMCase Services LLC · Scottsdale, AZN939BWPoky Feeders Inc · Scott City, KSN939DCCraine Daniel J · Fort Worth, TXN939RTInvestjet LLC · Miami, FLN939TWGulf Atlantic Airways Inc · Gainesville, FLN93CVRosebriar Holdings Corp · Dallas, TXN93DBForce Pressure Control LLC · Seguin, TXN93FSEubel Brady & Suttman Asset Management Inc · Miamisburg, OHN93HATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN941JPCypress Aircraft Sales LLC · Clermont, FLN941RJFly Red Lodge LLC · Red Lodge, MTN943TFHometowne Aviation LLC · Jackson, TNN944LSJmb Air LLC · Algona, IAN945SKJog001 Inc · Lewes, DEN946CGJk Aviation LLC · Grosse Ile, MIN946TSTsp Leasing Company LLC · Tacoma, WAN949SAN501wj LLC · Ottawa Lake, MIN94CHInvestjet LLC · Miami, FLN953FAffordable Equity Partners Inc · Columbia, MON953JFRwb Holdings LLC · Cheyenne, WY
Back to AD 90-06-13