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.
N4612JCentral Iowa Agricultural Aviation LLC · Wellsburg, IAN469LACounty Line Flying Service Inc · Coy, ARN4712JCentral Iowa Agricultural Aviation LLC · Wellsburg, IAN471HKSak II LLC · Miller, SDN473FSShannon Agricultural Flying Inc · Clarksdale, MSN474HAg Solutions Of West Texas LLC · Roby, TXN474LACat Agri Aviation Inc · Walnut Ridge, ARN475LAPost Rock Aviation Inc · Lincoln, KSN482ATAerinova Aerial LLC · Mattoon, ILN490SFWells Flying Services LLC · Holdrege, NEN496JBBank Of Utah Trustee · Salt Lake City, UTN49PAState Exchange Bank · Lamont, OKN5002WSouther Crop Spraying Inc · Douglas, GAN5003XJagco Inc · Middletown, DEN50050Mowata Farms LLC · Mamou, LAN5005KFisher Spray Service LLC · Cardington, OHN5006CAir Tractor Inc · Olney, TXN5006GBank Of Utah Trustee · Salt Lake City, UTN5006KWoods Aviation LLC · Kearney, NEN50071South Delta Aviation Inc · West Helena, ARN5008LOlathe Spray Service Inc · Olathe, CON5008YAir Tractor Inc · Olney, TXN5009PAir Tractor Inc · Olney, TXN50102Air Tractor Inc · Olney, TXN50105Air Tractor Inc · Olney, TXN5011DAir Tractor Inc · Olney, TXN5011HAir Tractor Inc · Olney, TXN5012GAir Tractor Inc · Olney, TXN5012HEvergreen Flying Service Inc · Dover, DEN5012LAir Tractor Inc · Olney, TXN5012TAir Tractor Inc · Olney, TXN5012XAir Tractor Inc · Olney, TXN5013FAir Tractor Inc · Olney, TXN5013MAir Tractor Inc · Olney, TXN5013VAir Tractor Inc · Olney, TXN5013ZAir Tractor Inc · Olney, TXN5014FAir Tractor Inc · Olney, TXN5014NAir Tractor Inc · Olney, TXN5015KBirddog Aviation LLC · Stockton, KSN5019YAir Sprayers Inc · Two Buttes, CON501JC4l A/C Leasing LLC · Port Saint Lucie, FLN5021UReed Aviation Inc · Iota, LAN50256Panola Flying Service LLC · Lake Providence, LAN5034RMid Missouri Spray Service LLC · Richmond, MON5035KAmberican Aviation Inc · Grand Forks, NDN5039FDixie Flying Service Inc · Gilliam, LAN503FAMccaleb'S Flying Service LLC · Plaucheville, LAN5043DSterling John A · Port Lavaca, TXN5045SAw Peterson Inc · Warren, MNN5048DFitchs Flying Service LLC · Pearsall, TX
Back to AD 2002-19-10