AD 2002-26-05
Registered aircraft · 502
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-26-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-26-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-26-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-26-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.
N3076WRba LLC · Kimberly, IDN3078TBarts Flying Service Inc · Storm Lake, IAN30832Bank Of Utah Owner Trustee · Salt Lake City, UTN312LARoth Aerial Spraying LLC · Milford, NEN313TWWiebe Aerial Applications LLC · Whitewater, KSN316WRHoxie Sprayers Inc · Hoxie, KSN319LACrop Air LLC · Eaton, CON321ATBank Of Utah Trustee · Salt Lake City, UTN321GAHoppe Air LLC · Beaman, IAN326LAMurtagh Flying Service Inc · Lexington, MSN329BRHorizon Air LLC · Lumpkin, GAN329KHDixie Air Applicators LLC · Itta Bena, MSN329RSolace Aerial LLC · Walnut Hill, FLN332LAHoran Spraying LLC · Plainview, TXN334LASun Valley Dusting Co · San Benito, TXN337MAMeyers Aerial Service LLC · Superior, NEN341LALake Washington Flying Service Inc · Glen Allan, MSN3636BAir Tractor Inc · Olney, TXN369AB3rd Gen Aviation LLC · Lisbon, NDN371LABruton Aerial Spraying Inc · Garden City, TXN373HDHinkle Air Spray Inc · Cavalier, NDN377LAFickes Aerial & Ag Services LLC · Norfolk, NEN394LAAerial Solutions Of Tennessee LLC · Milan, TNN407CTCrosswind Aviation LLC · Port Barre, LAN4109XSky Apply LLC · Hector, MNN410LASunnyside Aero Inc · Schlater, MSN411BFNorhtstar Aerospray Inc · Clara City, MNN412KHAircraft Trustee Services Inc Trustee · Dover, DEN41340Twist Air LLC · Earle, ARN4155PAndersons Flying Service Inc · Robbins, CAN41608Higgins Leasing Inc · Spring, TXN41612Puryear Rodney K · Pampa, TXN41675Registration Pending · Cavalier, NDRegistration pendingN41854Alpha Ag Air LLC · Little River, KSN41991Bravo Gildardo F · Mission, TXN4200SWood Flying Inc · Panhandle, TXN42086Beta Ag Inc · Ralls, TXN42190Matecumbe Flying Service Inc · Immokalee, FLN421CAD&D Aerial LLC · Gratiot, WIN4220WRegistered aircraftN4223GTowe Flying Service · Madison, ALN425BFBlue Earth Flying Service LLC · Blue Earth, MNN438RJSunflower Aero Inc · Atwood, KSN439PSTlb Air Llp · Grafton, NDN443LARubbert Jan · Upham, NDN445MSAas LLC · Ovid, MIN45019Aerial Solutions Of Tennessee LLC · Milan, TNN4501QConfederate Air Inc · Mcgehee, ARN4509STall Towers Ag Service Inc · Page, NDN45113Over And Under Flying Service Inc DBA · Knox, IN
Back to AD 2002-26-05