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.
N575CLilly David E · Allentown, PAN579PSFoxtrot Charlie Inc · Grass Valley, CAN57AGMonument Aviation LLC · North Chesterfield, VAN580RAGibson & Harrup Leasing LLC · North Dinwiddie, VAN585ATJr & M Air LLC · San Antonio, TXN586YDDodson International Parts Inc · Rantoul, KSN588SAReach Air Medical Services LLC · Santa Rosa, CAN588SDIal Corp · Lewes, DEN590SHAlliance Air Parts Acquistions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedN591AWCsi 135 Division LLC · Albuquerque, NMN595TMRegional Air Group LLC · Windermere, FLN597PGuardian Flight LLC · Lewisville, TXN598ATWohlford Aviation LLC · Ashland, NEN599BB3gs Air LLC · Fort Myers, FLN59KAParagon Office Services LLC · Dallas, TXN5TADodson International Parts Inc · Rantoul, KSN600ACLowcountry Aviation Co Brokerage LLC · Walterboro, SCN600BFCentral Virginia Aviation Inc · Petersburg, VAN601DMR & G Aviation LLC · Hazlehurst, GAN602DH2nd Amendment Wholesale Inc · Grand Forks, NDN603PACentral Virginia Aviation Inc · Petersburg, VAN606PC988sl Aviation LLC · Ridgeland, MSN608FBVortex Education Management LLC · El Cajon, CAN60BABemidji Aviation Services Inc · Bemidji, MNN60CDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeN60VPGuardian Flight LLC · Lewisville, TXN6111VSfh Inc · Fargo, NDN611CRV J Coleman And Son · Ackerly, TXN612FN612f LLC · Henderson, TNN613GGNcp Equipment LLC · Wilmington, DEN613RFB R S Leasing Inc · Wilmington, DEN615AASkydive San Joaquin Valley Inc · Bakersfield, CAN61698Wildfire Aviation LLC · Wilmington, DEN617MMCal-Ore Life Flight LLC · Brookings, ORN617RMMontana Sky Assets LLC · Helena, MTN6190SAir Logistics LLC · Savannah, GAN61GNGuardian Flight LLC · Lewisville, TXN61QDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeN6207FAir New England LLC · Portsmouth, NHN620TWStrega Ventures LLC · Boca Raton, FLN620WESouthwest Aviation Inc · Marshall, MNN623BBAirshares Incorp · Petersburg, VAN62SALta Group Holdings LLC · Amarillo, TXN62VDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeN640DFWhy Not LLC · Montezuma, KSN640RJMidwest Executive LLC · Reno, NVN642TDN642td LLC · Newark, DEN643EAAir Adventures Corp · Charleston, SCN644JCBic Aviation LLC · Fort Smith, ARN6492CSouth River Services LLC · Myrtle Beach, SC
Back to AD 2002-01-10