AD 2002-07-01
Registered aircraft · 3,466
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-07-01')
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-07-01')
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-07-01') 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-07-01') 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.
N733KDLake Clark Holdings LLC · Port Alsworth, AKN73408Shade Eric L · Dillingham, AKN7340UYr-Aircraft Leasing LLC · Bethel, AKN7341CT Cole Holdings I LLC · Paint Rock, TXN73467Ryan Air Inc · Anchorage, AKN7346PIntegrated Avionics Services Inc · Hampstead, MDN7347NAv8 LLC · Boise, IDN7349CMcbride Patrick J · Anchorage, AKN734CXMount Crillon LLC · Juneau, AKN734EJLavery Sam · Morgantown, WVN734GWRwr Air Inc · Tok, AKN734HW206 LLC · Portland, ORN734HXWaters Aero- Marine Inc DBA · South Thomaston, MEN734JCRegistered aircraftN734PPKelley Jon B · Anchorage, AKN734TMCorporate Air Service Inc · North Salt Lake, UTN734VSVitatoe Industries Inc · Chillicothe, OHN734WEMattie Joseph G · Ester, AKN734WGStone Aviation LLC · Traverse City, MIN734WHObermeyer Keith · Excelsior, MNN734WXRegistration Pending · Kodiak, AKRegistration pending, pending cancellationN73503Ryan Air Inc · Anchorage, AKN7351UBlue Waves Holding One LLC · Miami, FLN7357CPerson Donna Mae · Columbus, NEN7359CAhlem Charles D · Hilmar, CAN735BTPtmm LLC · Columbus, OHN735CEKangas Randy P · Fairbanks, AKN735JTStationair 6 LLC · Corinth, MSN735LSPatrick Andrew · Boise, IDN735MPHelms Aviation Inc · Long Lake, NYN735MWWaddell Byron · Henderson, NVN735MYVanderpool Robert W · Red Devil, AKN735QPCulver Marc D · Anchorage, AKN735XVGps Land Company LLC · Brandon, MSN7360CKacoyanis John George · Bedford, NHN73612American Aviation Inc · Page, AZN7361CFocused Holdings LLC · Wellsville, UTN73663Summit Lake Aviation Inc · Olympia, WAN7367CRuebling Edward X · Anchorage, AKN73727Redtail Partners LLC · Moab, UTN73733Muffett Pat D · Eastsound, WAN7373UYr-Aircraft Leasing LLC · Bethel, AKN73742Adams Bruce M · Santa Fe, NMN7375NEllison Air Inc · Anchorage, AKN73789Ryan Air Inc · Anchorage, AKN7379UIliamna Air Taxi Inc · Iliamna, AKN7384CFesco Holdings Inc · Alice, TXN7384UGrant Aviation Inc · Anchorage, AKN7386CAgro Engineering Inc · Alamosa, CON7389NKns Properties · Perry, IA
Back to AD 2002-07-01