AD 2002-19-10
Registered aircraft · 1,092
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-19-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-19-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-19-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-19-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.
N15210O'Hare R Mike · Clovis, NMN1529USnider Scott E DBA · Turner, MTN1531GWoodley Aerial Leasing LLC · Walnut, ILN1531SWakefield Aircraft LLC · Cooperstown, NDN1533SMj Aviation Inc · Walnut Ridge, ARN1534DEdge Aviation LLC · Moberly, MON1544RRas Aviation LLC · Elyria, OHN1546HAero Spray Inc DBA · Appleton, MNN15570Shearer Sprayers Inc · The Dalles, ORN155LALake Air Service LLC · Jennings, LAN157LAWakefield Aircraft LLC · Cooperstown, NDN159LAWilmot Airplane Ventures LLC · Dover, DEN166LAAeronautical Technologies Inc · Clovis, NMN167LATowe Boys Agri Service Inc · Madison, ALN169JTTidwell 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, TXN194LARtc Aviation LLC · Munday, TXN196CFAir Tractor Inc · Olney, TXN196LALocker Fred · Muleshoe, TXN20001Dcs Air LLC · Lewes, DEN2003JCon Air LLC · Lake Providence, LAN2003YOops LLC · Cheyenne, WYN20062Lissie Flying Service Inc · Lissie, TXN2007A2007a LLC · Hastings, NEN200LAAsap Flying Service Inc · Hermiston, ORN200WHDcs Air LLC · Lewes, DEN2017FBank Of Utah Trustee · Salt Lake City, UTN2017NKen 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, LAN203GHAurora Cooperative Elevator Co · Aurora, NEN2047VWilliamsburg Air Service Inc · Kingstree, SCN20576Bain Aviation Inc · Nyssa, ORN2059CPro Agri Spraying Service Inc · Ropesville, TXN205KCWalton Agwings Inc · Jonesboro, ARN20607Neal Aircraft Inc · Slaton, TXN2060HCleveland Air Service Inc · Cleveland, MSN2060MAerial Crop Protection Inc · Stuart, FLN2061DAaa Aviation LLC · Donalsonville, GA
Back to AD 2002-19-10