AD 2002-01-10
Registered aircraft · 816
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-01-10')
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-01-10')
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-01-10') 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-01-10') 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.
N252RCPrestige Worldwide Flights Two LLC · Imperial, CAN259SCCei Inc · Wilmington, DEN25GRBarrosa LLC · Scottsbluff, NEN261GBSafford Aviation Service Inc · Coolidge, AZN266RDGuardian Flight LLC · Lewisville, TXN267COldham Matthew Stephen · Lewisville, TXFirst renewal noticeN268CACaruthers LLC · Moundville, ALN26ARDale Aviation · Rapid City, SDN26EDynamic Avlease Inc · Bridgewater, VAN26RERrr Aviation LLC · Gulfport, MSN270MNardi Greg P · Missoula, MTN274KARgv Sky LLC · Harlingen, TXN275LARts Ventures LLC · San Antonio, TXN278SWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN282DBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN284MRDale Aviation Inc · Rapid City, SDN284PMArtic Legacy Aviation LLC · Anchorage, AKN28KPState Of Montana · Helena, MTN290CCMonument Aviation LLC · North Chesterfield, VAN290KAir Ems Inc · Tulsa, OKN290KAN290ka LLC · Clare, MIN290NCMr Boo Properties LLC · Indianapolis, INN290PASouthern Aircraft Consultancy Inc Trustee · Casper, WYN291CCMobile Ehr Inc · Argyle, TXN291DFRmb Leasing Inc · Dover, DEN292APlacebo Air LLC · Ridgecrest, CAN294TTUncommon Solutions LLC · Hollis, NHN299RPGuardian Flight LLC · Lewisville, TXN299VMSs Leasing LLC · Tulare, CAN29MBluesky Geospatial Ltd · North Adams, MAN2UVDependable Freight LLC · Bethel, AKN300AWDavis Aviation Inc DBA · Brandon, MSN300VAAeon62 Holdings LLC · Plano, TXN3030GDutch Aviation LLC · Perry, IAN303CAM&H Flight Services LLC · Kerrville, TXN305TTZulu Air LLC · Opa Locka, FLN305ZAZulu Air LLC · Opa Locka, FLN3066WFortis Aircraft Leasing LLC · Reno, NVN308CSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN308MDGem City Properties LLC · Laramie, WYN308RMN308rm LLC · Boca Raton, FLN30KCSkillman Management LLC · Wellington, FLN30PJHighland Paving Co LLC · Eastover, NCN312VFCentral Virginia Aviation Inc · North Dinwiddie, VAN313DWDurair Inc · Key West, FLN314LMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN314MRMiller Aviation LLC DBA · Huntington, INN315RPPro Serve Aviation LLC · Englewood, CON316MDH&D Bluesky LLC · Kalispell, MTN319MBAircraft Holding Solutions LLC Trustee · Newark, DE
Back to AD 2002-01-10