AD 94-05-05 R1
Registered aircraft · 26,230
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.
N9612AKm Aero Inc · Kalispell, MTN96144Kestly Daniel R · Chula Vista, CAN9615ADay Michael J · Fort Wayne, INN96163Malone Raine · Mcgrath, AKN96167Westrum Durl Troy · Norwalk, IAN9619ADanziger George E · Florence, MAN961LCSanpete Aviation LLC · Nephi, UTN96216Port Townsend Aero Museum · Port Townsend, WAN9623ASun 'N Fun Fly-In Inc · Lakeland, FLFirst renewal noticeN9624Krawchuck Paul L · Live Oak, FLN9624ASnead John S DBA · Crescent City, FLN9626AWebie Matthew W · Madison, ALN9629AWinover Orville J Jr · Tyler, TXN96320Everts Robert W · Fairbanks, AKN9632AHiter Henry P Jr · Merigold, MSN96330Koerber Scott T · Anchorage, AKN96337Hanson John G · Marion, MTN9633ASmith Herschell C III · Panama City, FLN9637AMutz Paul J · Rocklin, CAN9639APhyfe Andrew L · Cape Coral, FLN964Cranna Shane P · Rhinebeck, NYN96409Ryan Ashley R · Palmer, AKN9641AIsler Jerry L · Donalsonville, GAN9644ASchindler Patrick E · West Valley City, UTN9647ASilver Minnow LLC · Farmington, MNN9649APuls Kurt V · Valparaiso, INN964BWJohnson Marion F Jr · Donie, TXN9650AGraber Kirby D · Brooksville, MSN9651HWells James Ernest · Beavercreek, OHN9654ARegistered aircraftN9655HHetz Richard A · Fairview, PAN9656AKriley Kevin · Smith Center, KSN9658AMouser Jay F · Goldendale, WAN965CTCae Aviation Academy Phoenix LLC · Mesa, AZN965DCCrescenzo David G · Hammonton, NJN9660AYates Michael H · Darlington, MDN9661AEndsley Larry R · Waynesboro, VAN9664ZCamenzind Burton P · Palo Alto, CAN9667ALight For Living Inc · Harvest, ALN96691Blackstone Rotorcraft Inc · Hartselle, ALN9669ADella David Dan · Vacaville, CAN966CTChiaviello Christine T · Beaufort, SCN9672AJohnstone Deborah L · Edmonds, WAN9673AGiesbrecht Shane R · Grand View, IDN96752Schauer Tad J · Carpio, NDN96755Godbout Kevin P · South Hadley, MAFirst renewal noticeN967CTLawler Glenn M · Mooresville, NCN9681AKablau Frank · Elroy, WIN9682APenfield George R · Shreveport, LAN9683ARogers Wallace B · Salem, OR
Back to AD 94-05-05 R1