AD 94-05-05 R1
Registered aircraft · 26,231
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N2266DBeland Steven J Jr · Saint Ansgar, IAN2266EOtto David L · Lacey, WAN2266JRound Engine Aero · Nashville, MIN2266LPutnam Michael C · Topeka, KSN2266NBovington Thomas P · Helena, MTN2266VFerris Elden L · Vancouver, WAN22673Merry Robert J · Lynnwood, WAFirst renewal noticeN22676Burgess Barton C · Leesburg, OHN22677Barlow Rod · Kaysville, UTN2267VHast David W · Caledonia, MIN22680Turpen Andrew B · San Andreas, CAN22682Bianchi Brandon J · Castroville, CAN22686Tucker Lon R · East Peoria, ILN2268HCarden Keith A · Barneveld, WIN2268JKing Larry W · Port St John, FLN2268NSeabase Eric J · Benson, AZFirst renewal noticeN22692Registration Pending · Metairie, LARegistration pendingN2269KDelaney John T III · Bangor, PAN226WFSouthern Aircraft Consultancy Inc Trustee · Casper, WYN22702Ryan Good Aviation LLC · Sioux Falls, SDN22705Reeve Howard E · Minot, NDN22706Sego James G · Sequim, WAN22708Arispe Aviation LLC · Mckinney, TXN22709Riggin Flight Service Inc · Madison, SDN2270JFeland Wade · Antler, NDN2270VWise River Aviation LLC · Manhattan, MTN22716Rice Dwight D · Loma Linda, CAN2271KWarner Isaac F · Three Rivers, CAN2271NKasuske Gerald A · Watertown, SDN22722Roshchepa Yuriy · West New York, NJN22728Bero Patrick J · Pewaukee, WIN22729Gavriilidis Gavriil · Palm Harbor, FLFirst renewal noticeN2272BRackett Cary A · Goodrich, MIN22731Renehan Daniel G · Holly, MIN22738Barbaree Chan · Elba, ALN2273DHorkan Tracy J · Reedsburg, WIN2273HWright Colleen E · Punta Gorda, FLN2273VMarsh John E · Washington, DCN22741Wayne Brett M · Saint George, UTN2274DHernandez Michael Nazario · Orange, CAN2274JStone Kenneth R · Cedar Springs, MIN22758Clip Aire LLC · Mill Spring, MON2275DJordan Ken W · Frankfort, KYN22764Rice Allen P · Caldwell, IDN22765Registration Pending · Buckeye, AZRegistration pendingN22771Whitney Walter F · Ham Lake, MNN2277NMillikan Jeffrey C · Trinity, NCN22780Padgett Michael A · Ruffin, SCFirst renewal noticeN22784Mayeko-Coklee Thomas · Lake Worth, FLN22785Williams Jamar C · Louisville, KY
Back to AD 94-05-05 R1