AD 2002-12-07
Registered aircraft · 63,519
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-12-07')
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-12-07')
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-12-07') 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-12-07') 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.
N103MDCarson Business Systems Inc · Carson City, NVN103MPJoyce George E · Franklinville, NCN103MRDeepvine Partners LLC · Simonton, TXN103NCState Of North Carolina · Raleigh, NCN103PZRaging Thermal Sky Sports LLC · Brighton, CON103RRLancaster Flyers LLC · Fenwick Island, DEN103RSZielke Michael M · Chuluota, FLN103SAHolman Steven R · Vero Beach, FLN103SJBarnick Air Holdings LLC · Santa Barbara, CAN103SPAllen Mark · Waynesboro, VAN103TBSugasa David · Imlay, NVN103TTAero Dynamics Flying Club Inc · Mulino, ORN103TXWilliams Bradley H Jr · Charleston, SCN103URankin Kenneth · Pinellas Park, FLN103VWVan Wagner Aerial Media LLC · Hollywood, FLN103WCBurklund Joshua S · Milaca, MNN1040JHefferon John W · Locust Grove, GAN1040UAmerican Aviation Inc · Brooksville, FLN1040XRacette Robert J Jr · Vienna, WVN10410Clark George A · Worcester, MAN1041CHelzer Timothy · Tucson, AZN1041HCentury Flight Systems Inc · Mineral Wells, TXN1041QSwaz Aviation LLC · Mesa, AZN1041SN1041s LLC · Key West, FLN1041URegistered aircraftN1041XGyllensten Scott · Guilford, CTN10420Kinney Powell Mcvay · Coppell, TXN10421Registered aircraftN1042JJac LLC · Denham Springs, LAN1042PMcalpine David B · Fort Worth, TXN1042SPiper Cameron · Winchester, VAN1042UShackleford Developments Of Sc LLC · Mount Pleasant, SCN1042XN1042x LLC · Papillion, NEN1042ZMatthews Casey B · Belmont, NCN1043JLanmon Herman Jr · Hamilton, TXN1043QRegistered aircraftN1043SAmerican Aviator LLC · Newark, DEN1043UClinton Arlys L · Fair Oaks, CAN1043XAustin Security Corp · Battleboro, NCN10446Schell Brothers II LLC · Rehoboth Beach, DEN1044FNottorf Eric W · Keller, TXN1044JNagasaka Bruce J · Weiser, IDN1044LFitch Mark · Anchorage, AKN1044NMaule Flight Inc · Moultrie, GAN10457Six Ten Ventures LLC · Cedar Hill, TXN1045JFenn Matthew A · Liberal, KSN1045LBernard Robert J · Millbury, MAN1045RKersting Thomas J · Volga, SDN1045YRovers Bradley S · Chazy, NYN1046BOglesby Jonathan D · Okmulgee, OK
Back to AD 2002-12-07