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.
N3572Kindred Douglas G · Eugene, ORN3572CFrasca John A · Champaign, ILN3572JUpchurch Air And Sea LLC · Fort Lauderdale, FLN3572SWeidman Paul D · Lebanon, PAN3572THaase Israel A · Wasilla, AKN3572VRoberts Nigel C · The Plains, VAN3573DBohl Howard M Jr · Long Beach, CAN3573LGlasgow Jason D · Tecumseh, OKN35745Smith Robert D · Roanoke, TXN3574LMillican Marc J · Anchorage, AKFirst renewal noticeN3574TCalifornia Airways LLC · Hayward, CAN3574VRau Bradley W · Payette, IDN3575DTufts Peter A · Bethel, CTN3575JSv Aviation LLC · Gilbert, AZN3575VSale Reported · Acworth, GASale reportedN35764Routh Gary L · Lebanon, TNN3576CRamaswamy Gautam · Clearwater, FLN3576DVorpagel Stephen L · Readfield, MEN3576SGarrison Jerry L · Leavenworth, KSN3576TSplonskowski Steven J · Oregon City, ORN3576ZRaymond Jeff R · Fairbanks, AKN3577CCrystoff James J · Kodiak, AKN3577JArvo Aviation LLC · Newport Beach, CAN3577LWimpey Robert J · Roundhill, KYN3577STorman Kevin B · Umatilla, FLN3577TChaplin Lyndon Yeager · Anchorage, AKN3578JCaswell David B · Owosso, MIN3578SHigley Jon · Jerome, IDN3578TMeachen Jeffry · Chippewa Falls, WIN3578V198 Main Street Aviation LLC · Sullivan, WIN35793Mcenery Brian T · Elmendorf, TXN3579CA&J Aeronautics LLC · Nerstrand, MNN3579DSchumacher Thad A · Wasilla, AKN3579TWilke Daniel D · Fairmount, NDN3579VGreslin Michael D · Spearfish, SDN357BFRezac Lauren J · Wichita, KSN357HPAllred Thierry J · Casa Grande, AZN35809Merritt Robert L · Afton, WYN3580JJamieson Robert F · Friday Harbor, WAN3580TYliniemi Glenn C · Frazee, MNN3580ZRoma Air Corp · Belle Glade, FLN35819Erickson Mark D · Valley Springs, SDN3581FSkyline Aviation Services LLC · Miramar, FLN3581HDickard Gary D · Kimberly, IDN3581NClement Jesse W · Louisville, KYN3581VBryan Les E · Evansville, INN35822Mcrobie Roger L · Maryville, TNN3582CBenedict Larry D · Dexter, NMN3582DFrench Guy · Maple Valley, WAN3582JMorris Jon · Thatcher, AZ
Back to AD 94-05-05 R1