AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N2582ZChandler Air Service Inc · Chandler, AZN25830Surette Rosemarie · Vail, CON2583WRuckel Daniel A · Floyds Knobs, INN2585WClassic Mooney Nv LLC · Henderson, NVN2586WVizinat David C · Ragley, LAN2586XPiper Kffc LLC · Peachtree City, GAN2586ZFernandez John III · Cape Canaveral, FLN2587WOrourke Timothy L · Laguna Niguel, CAN2588MN-J Aviation LLC · Forest, VAN2588TAircraft Trustee Services Inc Trustee · Dover, DEN2588WJohnson Mitchell R · Bismarck, NDN2589WHart Christian L · Highland Village, TXN258AKThompson Nick · Eagle, AKN258CVandelay Industries I Inc · Wilmington, DEN258CACoast Flight Training And Management Inc · San Diego, CAN258DLExtapa LLC · Wilmington, DEN258EPEpic Aviation Inc · New Smyrna Beach, FLN258MEGolf Delta Charlie LLC · Baton Rouge, LAN258MGGeorgia Aviation Authority · Eastman, GAN258REEbel Roy J · Hot Springs, SDN258SBSkyfusion II LLC · Atlanta, GAN258SCBlue Border LLC · Blue Earth, MNN258SHWilmarth Russell · Alton Bay, NHN258VF1r14a LLC · Huntersville, NCN2590QConant Edward · The Woodlands, TXN2590WWheeler James N · Shreveport, LAN2590ZWollaston Dean E · Hazel Green, WIN2593RWeatherly Lloyd W · Wittmann, AZN2593WUehlin Bradley S · Danbury, NEN2593ZGuillen Gregorio J · Phillipsburg, NJN2594WMcclure Richard A · Victoria, TXN2595WReid Lois M · Dallas, TXN2596PCarlson Eric S · Kodiak, AKN2596WClark Richard · Towanda, PAN2598NRed Tail Scholarship Foundation · Tuskegee, ALN2598RRiff Raff Air LLC · Isle La Motte, VTN2598WSunset Aviation LLC · New Iberia, LAN2599RNeo Aero LLC · Youngstown, OHN2599WBinger Thomas C · Stillwater, MNN2599ZAirborne Images Inc · Encino, CAN259ATAirline Transport Professionals Corp Of USA · Wilmington, DEN259BDRainier Flight Service LLC · Renton, WAN259CBCalifornia Baptist University · Riverside, CAN259CFMander John E · Kingston, TNN259DWSmith Jason · Calliham, TXN259EPEpic Aviation Inc · New Smyrna Beach, FLN259GFPerformance Aircraft Sales Inc · Lincoln, NEN259JSCrystal Coast Training LLC · Kinston, NCN259MGGeorgia Aviation Authority · Eastman, GAN259RAReynolds Darryl G · Wills Point, TX
Back to AD 2006-10-21