AD 2002-22-17
Registered aircraft · 1,016
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:2002-22-17')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-22-17')
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:2002-22-17') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-22-17') 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.
N411GVPa1 208b-0672 LLC · Fort Lauderdale, FLN412TFBig Grand Aviation LLC · Jupiter, FLN414CYLifesouth Community Blood Centers Inc · Gainesville, FLN415TTT & T Capital Inc · Bangor, MEN41GRRiley Aviation LLC · Wht Sphr Spgs, MTN41TEMaple Aviation LLC · New York, NYN420DZDesert Sand Aircraft Leasing Co Inc · Rosharon, TXN421SYBank Of Utah Trustee · Salt Lake City, UTN424AGDancing On A Dream Inc Trustee · Wilmington, DEN426KMKenmore Air Harbor LLC · Kenmore, WAN430TXTexas Department Of Public Safety · Austin, TXN435MTSouthwest Aviation Solutions LLC · Las Vegas, NVN4365UWright Air Service Inc · Fairbanks, AKN437JPKachemak Bay Flying Service Inc · Huntsville, ALN438JPKalinin Partners LLC · Juneau, AKN4395WRoberts Aviation LLC · Acworth, GAN43CW42f LLC · Key West, FLN443JPSouthern Aircraft Consultancy Inc Trustee · Casper, WYN449PEBank Of Utah Owner Trustee · Salt Lake City, UTN450KPKalinin Partners LLC · Juneau, AKN452TWright Air Service Inc · Fairbanks, AKN454SFPa1 208b-0797 LLC · Fort Lauderdale, FLN459WMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN4625BMartinaire Aviation LLC · Addison, TXN462JSState Of Iowa · Des Moines, IAN463DBThunderhook Air Inc · Brentwood, TNN4655BMartinaire Aviation LLC · Addison, TXN4662BRedding Aero Enterprises Inc · Redding, CAN4667BUnited States Department Of State · Melbourne, FLN4674BRedding Aero Enterprises Inc · Redding, CAN4687BMartinaire Aviation LLC · Addison, TXN473TWNv5 Geospatial Inc · Sheboygan Falls, WIN477XPParaclete Aviation LLC · Raeford, NCN47CLAircraft Structures International Corp · Enid, OKN485JRGuardian Flight LLC · Lewisville, TXN485SATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN485YUGen Board Of Global Ministries Of The United Metho · Atlanta, GAN490SATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN495SASouthern Airways Pacific LLC · Addison, TXN496SASouthern Airways Pacific LLC · Addison, TXN498GGPleasant Aircraft Leasing LLC · Newbury Park, CAN501EXFloatsix Leasing LLC · Wilmington, DEN502GVGrant Aviation Inc · Anchorage, AKN503MKJay Bruber LLC · Saint Paul, MNN505GCWilmot Airplane Rentals LLC · Mer Rouge, LAN50648Lindsey Aviation Services · Haslet, TXN507TXTextron Aviation Inc · Wichita, KSN508BHCity Of Anaheim · Fullerton, CAN508RBCirrus 5100 LLC Trustee · Wilmington, DEN508RJBank Of Utah Trustee · Salt Lake City, UT
Back to AD 2002-22-17