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.
N3066LBank Of Utah Trustee · Salt Lake City, UTN30674Jlw Aviation Inc · Carlisle, ARN30676Michaelis Gary DBA · Goodwin, ARN3067JHartley Flying Service Inc · Stuttgart, ARN3069SRoma Air Corp · Belle Glade, FLN3070EG B Aerial Applications Inc · Slaton, TXN3070FDakota Air Spray LLC · Huron, SDN3070GWilliamsburg Air Service Inc · Kingstree, SCN3072YAero Spray Inc DBA · Appleton, MNN30757Moses Lake-Warden Air Service Inc · Moses Lake, WAN307BRRice Flying LLC · Poplar Bluff, MOFirst renewal noticeN3082PCustom Air Inc · Roe, ARN3082VMid Missouri Spray Service LLC · Richmond, MON3083KBoyds Aviation LLC · Rayville, LAN3083RAero Spray Inc DBA · Appleton, MNN3085QAero Spray Inc DBA · Appleton, MNN3086AArrow Aviation Inc · Broken Bow, NEN309PFPalmer Flying Service Inc · Manito, ILN313FAAg Air Flying Service Inc · Toppenish, WAN3160QAg Cat Applicators LLC · Avoca, TXN31626James Richard W · Chowchilla, CAN3164BL & L Flying Inc · Glen Allan, MSN3166YDixie Crop Care Inc · Dixie, GAN316LAAir Tractor Inc · Olney, TXN321DASherer Robert O · Deadwood, SDN324BSB&S Air Inc · Lumpkin, GAN325BMFarm Air Service Inc · Tallulah, LAN329LAWells Flying Services LLC · Holdrege, NEN332ATAg Solutions LLC · Satanta, KSN332BSHog Air Aviation Inc · Paragould, ARN333BRB&R Aerial Crop Care Inc · Connell, WAN334BSMitchell Andrew D Trustee · Winnie, TXN335BSOld River Flying Service LLC · Helena, ARN335LAAir Tractor Inc · Olney, TXN335QFBearcreek Flying Service LLC · Oakes, NDN339BSB & S Air Inc · Lumpkin, GAN340LATri-Air Farms LLC · Mamou, LAN344VAAir Tractor Inc · Olney, TXN347BMAir Tractor Inc · Olney, TXN347ERO'Briens Flying Service Inc · Iowa, LAN347REAir Tractor Inc · Olney, TXN349ASAero Applicators Inc · Sterling, CON350DAAir Tractor Inc · Olney, TXN354FSAnderson Interests LLC · East Bernard, TXN358ASNew Frontier Aviation LLC · Fort Benton, MTN363ATAeronautical Technologies Inc · Clovis, NMN363GSParrish Aerial Services LLC · Wilmington, DEN3652ZCotton Ag Inc · Walters, OKN3654GDixie Flying Service Inc · Bradley, ARN3655TPutz Gary D · Hearne, TX
Back to AD 2002-11-05