AD 89-02-10 R1
Registered aircraft · 603
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:89-02-10-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:89-02-10-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:89-02-10-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:89-02-10-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.
N880CFBoss 8 LLC · Fort Worth, TXN880ECDodson International Parts Inc · Rantoul, KSN883LDV-Jet Aircraft Holding Co Trustee · Dover, DEN884ABJetsteam Aviation Inc · Cheyenne, WYN884BBHf III LLC · Saint Paul, MNN884CFN360kv LLC · Modesto, CAN887MRFouga LLC · Dover, DEN8881JGdc Aviation LLC · Jacksonville, FLN888CSZg Aviation LLC · New York, NYN888ESSpinair LLC · Saratoga, CAN888FRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN888MFSn 1268 Inc · Wilmington, DEN888YGGy Gulfstream LLC · Las Vegas, NVN889BHPrima Air Group LLC · Pasadena, CAN889CGPrima Air LLC · Pasadena, CAN893TASta Aviation Management · New York City, NYN898Rare Air Aviation Services LLC · Santa Rosa, CAN899ALGulfstream Givsp 1495 LLC · East Hampton, NYN900BKRck Aviation LLC · Woodside, CAN900DTega Air LLC · Bend, ORN900EEIrish Air II LLC · Cincinnati, OHN900ERJdr 192 LLC · Woody Creek, CON900KUFalcon 900-91 LLC · Lewes, DEN900KWAlta Airlines Holdings LLC · Salt Lake City, UTN900LCMid Central Leasing LLC · Waukegan, ILN900LPDoctair Inc · Mclean, VAN900MKRacer X LLC · Chicago, ILN900MWGlobal Jet Partners LLC · Scottsdale, AZN900SBBg Air LLC · Hobbs, NMN900SFFalcon 900 LLC · Mount Laurel, NJN900TEFalcon 900 LLC · Ocala, FLN900TNRegistered aircraftN900VCFalcon-121 LLC · Salem, ORN900VPJdr 194 LLC · Woody Creek, CON900WRReaud Wayne A · Santa Fe, NMN900YBBold Access LLC · Leawood, KSN900YYBbps Aviation LLC · Mckinney, TXN901KRAvatar Wings LLC · Dallas, TXN905FJTvpx Trust Co LLC Trustee · North Salt Lake, UTN905LPChateau Aviation LLC · Wilmington, DEN908JTValiair Lc Trustee · Casper, WYN90FJWorldwide Aircraft Services Inc DBA · Tampa, FLN90GPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN90RGRobtoria Aircraft Leasing LLC · Wilmington, DEN90THJ & J Capital Ventures LLC · Wilmington, DEN910AFAfh Aviation LLC · Mineola, NYN910NMTriangle Real Estate LLC · Saint Peters, MON910SCSunchasing LLC · Newark, DEN910TX900 Consulting LLC · Austin, TXN913SCAircraft Holding Solutions LLC · Newark, DE
Back to AD 89-02-10 R1