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.
N2003BBrylen 502 LLC · Dumas, TXN2019PAgricultural Air Services LLC · Jupiter, FLN2022YPinecliff Aerial Inc · Camilla, GAN2032KKing Ag Leasing Inc · Sudan, TXN2035EGibson Flying Service Inc · Marianna, ARN2038QAt402 LLC · Banquete, TXN2040EWeaver Flying Service Inc · Quincy, WAN2045GOught 9 LLC · East Helena, MTN20527Tr Flying Service LLC · Milan, MNN205CGSeewald Jeffrey W · Great Bend, KSN205RMLissie Flying Service Inc · Lissie, TXN2066EEdwards Flying Service Inc · Leland, MSN208VVT&T Highcountry Flying Service LLC · Saint Anthony, IDN2094MCmk Aerial Inc · Sutton, NEN226DHCottonwing Air LLC · Indianola, MSN243LAH & G Farms Inc · Corcoran, CAN244PWAdams Aerial Solutions LLC · Decatur, ILN246BRRoberts Ag Air Service Inc · Lamoure, NDN247LFWilliamsburg Air Service Inc · Kingstree, SCN249LABank Of Utah Trustee · Salt Lake City, UTN252LABas Part Sales LLC · Greeley, CON254LAObriens Flying Service Inc · Iowa, LAN256MSBuck N Aviation Inc · Fort Worth, TXNon-citizen corporation, flight hours not reportedN261JBJb Leasing LLC · Norfolk, NEN268TWAircraft Trustee Services Inc Trustee · Dover, DEN270TWMattern Rodney M DBA · Dawson, NDN272LAB & D Aircraft Leasing LLC · Waupun, WIN273GCO'Briens Flying Service Inc · Iowa, LAN275ATBoardman Air Service LLC · Henderson, NEN275JAGibbs Aviation Inc · Fremont, OHN277LAA & M Flying Service Inc · Carlisle, ARN282XPProp Ag LLC · Montezuma, KSN289JARiceland Aviation Inc · Jennings, LAN290LAAscend Ag Inc · Wall, SDN297FAWalhalla Ag Service LLC · Walhalla, NDN3025PDakota Air Spray LLC · Huron, SDN302PCAerial Crop Protection Inc · Belle Glade, FLN30411Farm Air Inc · Astoria, ILN30523R & R Flight Service Inc · Mendota, ILN30539Midwest Aerial Spraying LLC · Dorchester, NEN3063HBank Of Utah Trustee · Salt Lake City, UTN3066VMurtagh Flying Service Inc · Lexington, MSN3067WMg37 Investments LLC · Holdrege, NEN3071KAurora Cooperative Elevator Co · Aurora, NEN3071WWood Flying Inc · Panhandle, TXN3072FGreat Plains Application LLC · Slayton, MNN3073CCentral Plains Spraying Inc · Hart, TXN3074FDeterding James L DBA · Pond Creek, OKN3075D49 Flying Service LLC · Greenwood, MSN3076HPost Rock Aviation Inc · Lincoln, KS
Back to AD 2002-26-05