AD 2002-11-05
Registered aircraft · 948
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-11-05')
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-11-05')
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-11-05') 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-11-05') 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.
N1529WOlathe Spray Service Inc · Olathe, CON1531GWoodley Aerial Leasing LLC · Walnut, ILN1531SWakefield Aircraft LLC · Cooperstown, NDN1533SMj Aviation Inc · Walnut Ridge, ARN1534DEdge Aviation LLC · Moberly, MON15439Dietz Timothy E · Wasilla, AKN15449Headwaters Flying Service LLC · Three Forks, MTN1544RRas Aviation LLC · Elyria, OHN1546HAero Spray Inc DBA · Appleton, MNN1546UBauer Charles A · Graceville, MNN1546XHopkins Robert E Jr · Sumter, SCN1554KBasin Aviation Inc · Rio Oso, CAN15570Shearer Sprayers Inc · The Dalles, ORN157LAWakefield Aircraft LLC · Cooperstown, NDN166LAAeronautical Technologies Inc · Clovis, NMN169JTTidwell Flying Service Inc · Carlisle, ARN173TANew Frontier Aviation LLC · Fort Benton, MTN174MLNew Frontier Aviation LLC · Fort Benton, MTN175LAMitchell Andrew D Trustee · Winnie, TXN1802MMeyerkorth Aviation LLC · Rock Port, MON1802QPontiac Flying LLC · Pontiac, ILN182PBDodson International Parts Inc · Rantoul, KSN187LALocker Fred · Muleshoe, TXN18KDH & W Ag Services Inc · Veribest, TXN194BMBombero Aviation LLC · Childress, TXN194CAAir Tractor Inc · Olney, TXN196CFAir Tractor Inc · Olney, TXN196LALocker Fred · Muleshoe, TXN20001Dcs Air LLC · Lewes, DEN2003YOops LLC · Cheyenne, WYN200LAAsap Flying Service Inc · Hermiston, ORN200WHDcs Air LLC · Lewes, DEN2017NKen Grubbs Aero Inc · Harrisburg, ARN2022BWil-Co Flying Service LLC · De Witt, ARN2022QHartley Flying Service Inc · Stuttgart, ARN202FHTr Flying Service LLC · Milan, MNN2039YDelta Dusters LLC · Newellton, LAN2047VWilliamsburg Air Service Inc · Kingstree, SCN205KCWalton Agwings Inc · Jonesboro, ARN20607Neal Aircraft Inc · Slaton, TXN2060HCleveland Air Service Inc · Cleveland, MSN2060MAerial Crop Protection Inc · Stuart, FLN2064JPadgett Ag Rotors LLC · Missoula, MTN2065SSteggs Aerial Spraying Inc · Alva, OKN2067EFarm Air Flying Service LLC · Sacramento, CAN20700Meyerkorth Aviation LLC · Rock Port, MON20718Cartillar Enterprises Inc · Wynne, ARN20726A&M Flying Service Inc · Carlisle, ARN2072DPadgett Ag Rotors LLC · Missoula, MTN207LALocker Fred · Muleshoe, TX
Back to AD 2002-11-05