AD 94-05-05 R1
Registered aircraft · 26,232
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.
N8103BJafar Farid G · Pine Bluff, ARN8103LSoaring Mrt LLC · Lake Charles, LAN81040Bas Part Sales LLC · Greeley, CON81044Air Transport Inc · Las Vegas, NVN81049Allen John B Jr · Sutter Creek, CAN8104BRomar Mark A · Massillon, OHN8104FDunham John P · Colorado Springs, CON8104SFlowers Tony C · Panhandle, TXN8104TBrewer Lance A · King Salmon, AKN8104UMellen Dennis L · Peoria, ILN81051Driskill David M · Garden Ridge, TXN81054Jansen Charles C · Machesney Park, ILN81055Van Steenis William W · Boulder City, NVN81057N81057 LLC · Seattle, WAN81059Lyon Patrick · Elkton, MDN8105LIowa Skyhawk LLC · Charles City, IAN8105TButcher Nicholas R · Litchfield Park, AZN81064Borkowski Steven S · Summerfield, NCN81065Ramaswamy Gautam · Clearwater, FLN81066Dunn Michael E · Queen Creek, AZN8106FHoward Mason · Phoenix, AZN8106SMay Jason L · Alva, OKN8106XJones Wayne D · Huron, SDN81071Registered aircraftN81073Larson Dustin · Baldwin City, KSN8107AE=Mc2 LLC · Prescott Valley, AZN8107LConrad Adam C Jr · Duncansville, PAN8107SChalmers Ashley · Manalapan, NJN81083Klugman Dale F Trustee · Helena, MTN81084Murphy Matthew L · Harlem, GAN8108ACraig Benjamin C · Wasilla, AKN8108FSale Reported · Greenback, TNSale reportedN8108SGray Ronald W · Hooker, OKN8108TEarly Robert A · White Oak, TXN8108UTimko Jacob E · Levittown, PAN8108XReding Joel M · Whittemore, IAN81093Samson Joseph R · Eagle, WIN8109AWatkins Brian · Bowling Green, KYN8109LVajgrt Richard Eugene · Mobile, ALN8109SWillis Quinton Blair · Murfreesboro, TNN8109TStoots David A · Fairbanks, AKN810KTDavis John M · Fairhope, ALN8110LMiller Brian T · Savage, MNN8110SV B Aviation LLC · Peachtree City, GAN8110UHeigle Randall K · Fouke, ARN8111BTaylor Brad · Alma, GAN8111SDavis Ronald K · Havelock, NCN8111XPhillips Zachary T · Kettering, OHN81123Em Flight Services LLC · Homestead, FLN8112UHaleco LLC · Pensacola, FL
Back to AD 94-05-05 R1