AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
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:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') 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.
N2981TKool-E5 LLC · Valdosta, GAN2981YBeebe Michael · Rangeley, MEN29821Jks Enterprises Inc · Park Rapids, MNN2982ASkywagon Pilots Inc · Santa Clara, CAN2982KHalcomb Billy J · Pond Creek, OKN2982LBurgdorf Brandon M · Evansville, INN2982XSale Reported · Lakeland, FLSale reported, canceledN2983FHalle Michael P · Livingston, TXN2983PEastgate Motors Inc · Salem, ORN2983TSlatter Lowell J · Buhl, IDN2983XEagle Sky Patrol Inc · Deadwood, SDN2983ZFisher Charlton D · Houston, TXN2984CRosser Brian K · Minden, NVN2984YRondeb Aircraft LLC · Wilmington, DEN29859Dangelo Thomas M · Plymouth, MIN2985CBraham John P · Fairbanks, AKN2985LHeskett Sean D · Steamboat Springs, CON2985THuskey Ryan J · Guthrie, OKN2985XFrazier James R · Adamsville, TNN2985YJones Aviation Inc · Biggs, CAN2986AMorris Blain E · Delta Junction, AKN2986EYbarguen Johnny C · Rosenberg, TXN2986KSmith John F III · Middletown, DEN2986PBentley Aero Inc · Wilmington, DEN2986RArmstrong Dustin L · Hobbs, NMN2986ZWharton Betty E · Amarillo, TXFirst renewal noticeN2987CYount Lawrence F · Shelton, WAN2987FRegistered aircraftN2987PSmall Mark B · Walla Walla, WAN2987TDaly Arthur P · El Paso, TXN2988BLongobardo Anthony · San Clemente, CAN2988FTaf Aerial Services LLC · Beeville, TXN2988KMelvin Perry D · Warner Robins, GAN2988PKadrmas Ryan · Dickinson, NDFirst renewal noticeN2988RSpilman Kathleen M · Mandan, NDN2988TSwiftmeyers LLC · Benton Harbor, MIN2988XDoyle Thomas P · San Diego, CAN2989Reavely Richard T · Madison, CTN2989MInternational Air Services Inc Trustee · Carson City, NVN2989TMid America Museum Of Aviation And Transportation · Sioux City, IAN2989XLabadie Enrique L · Tucson, AZN298ACEagle Prairie Flyers LLC · Eau Claire, WIFirst renewal noticeN298BCFlight School Of Gwinnett · Lawrenceville, GAN298CACurtis Caleb K · Pittsfield, MEN298CPCivil Air Patrol · Maxwell Afb, ALN298CSCirrus Sr22 Somex Inc Trustee · Wilmington, DEN298DBButler John P · Hazelhurst, WIN298DCVadnais Kenneth · Santa Barbara, CAN298FMStuart Scott · Lincoln, NEN298FSChupp Aaron · Gallipolis, OH
Back to AD 2007-04-19 R1