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.
N35MXMontanez George O · Mesa, AZN35NBBert John Boyd III · Vero Beach, FLN35NYPerry Charles E · Aldie, VAN35PHTsi Holdco Inc · Virginia Beach, VAN35QTReady Aim Flyer LLC · New Castle, DEN35RBBarnes Roger A · Cheyenne, WYN35RCG5 Aviation Inc · Englewood, CON35REDakota Aero Inc · Steamboat Springs, CON35RKKropp Richard G · North Creek, NYN35RSSudderth Robert W · Holly Lake Ranch, TXN35RXRight Rudder Flight Training LLC · La Verne, CAN35SHulteen Grant S · Tumwater, WAN35SCCramp Steven J · Cleveland, TXN35SHSmith Floyd D · Centralia, WAN35TBCencalcom Inc · Santa Barbara, CAN35TCLynn David R · Mobile, ALN35TEOusley James Dean Jr · Granbury, TXN35TJBeech D9462 LLC · Perry, OHN35TPMccallister Mark A · Qulin, MON35TTJ B & B LLC · Midwest City, OKN35TXBauries Brian W · Abilene, TXN35UKInternational Air Services Inc Trustee · Carson City, NVN35VBEquipment Lessors Inc · Lake Hawatha, NJN35VEMckibben Howard Stephens · Elk Grove, CAN35VHBarr Air Patrol LLC · Mesquite, TXN35VSRcp3 Enterprises LLC · Chesterfield, MON35VZAlons Kevin D · Salix, IAN35WCHawley Flying Club Inc · Fargo, NDN35WD4lo Air & Land LLC · Damascus, ORN35XFCaudle David William · Arlington, TXN35XLWilliams James R · Scotts Valley, CAN35XTWrench John D · Los Olivos, CAN35YRTonini Farm And Cattle Co · San Luis Obispo, CAN35YTArmstrong Samuel V · Lovelock, NVN35ZFlood Joseph W · Franklinville, NJN35ZQZq Navigation LLC · Bellingham, WAN36008Bas Part Sales LLC · Greeley, CON3600PPaul Mike · Sprague, WAN3600RArapahoe Flight Club LLC · Colorado Springs, CON3600URiera Jose Gregorio · Saint Augustine, FLN3600ZDay Charles W · Sedan, KSN36010Eskildsen Chris A · Connell, WAN36011Titus Larry E · Springview, NEN36013Jones Joseph D · Broken Arrow, OKN3601CLloyd Land Plane IV LLC · Brighton, CON3601ELsn Air LLC · Morrison, CON3601PCox Jay D · Perryton, TXN3601QWard Harry W Trustee · Williamsburg, VAN3601WPrecision Landings Inc · Wilmington, DEN3601XHarrell Joshua Thomas · Forsyth, GA
Back to AD 2007-04-19 R1