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.
N45256Albertson James M · Westville, FLN4525ESattler Joseph C · Waverly, OHN45262Wyoming Aviation Association Inc · Cheyenne, WYN45263Ruder Bonita E · Maple Park, ILN4526CWhitson Ryan L · Audubon, NJN4526EMcgill Alvin R · Joliet, MTN4526MGlasheen Sean T · Bethel, AKN4526UDrewelow Kevin R · Topeka, KSN45270Lessley Gavin W · Carrollton, MSN45274Robinson Charles F · Portage, MIFirst renewal noticeN4527UToth Karl A · Fair Oaks, CAN45281Stewart Patrick D · Reading, MIN45284Kelley Keith B · Forney, TXN45285Bennett Aaron K · Pulaski, VAN4528CMcgough N C · Ferris, TXN4528MBatie Russell J · Colstrip, MTN4529CVandenbelt Kenneth J · Leslie, MIN4529ELong Tuggin D · Smithville, MON452YRChichitz De Burrows Nadia M · Mcallen, TXN45302Missinne Brett R · South Range, WIN45308Berry Thomas F · Emmett, IDN4530CO Connor Mary B · Anchorage, AKN4530UWorthington Gary · Swifton, ARN4531CGear N The Well LLC · Melbourne, FLN4531EJohnson Donald B · Lino Lakes, MNN45327Cullen Richard J · Oshkosh, WIN45328N45328 LLC · Naples, FLN4532CHopkins Daniel E · Chandler, AZN4532EFloura David P · Blackduck, MNN45335Keeney Daphne C · Fairbanks, AKN4533CBerwick Robert G · Sonoma, CAN4533ETurner Rolf R · Sauk Rapids, MNN4533MGaskill Douglas D · Miles City, MTN45341Taylor Robert S · Satsuma, ALN45342Skybound Aviation LLC · Bixby, OKN4535Van Meter Alan P · Wichita, KSN45350Kelley Konrad E · Grant Valkaria, FLN45351Dallas Permian LLC · Mckinney, TXN4535EJensen Cynthia B · Olympia, WAN45361Price Gregory D · Frankfort, ILN45364Boren James Mason · Jasper, ALN4536ELa Rue Carl A · Cambridge, OHN4536MChristensen Robert P · Ashton, IDN45375Eastern Slope Aviation Academy · North Conway, NHN45376Jones Sharon J · Faulkton, SDFirst renewal noticeN4537EKyle Lara K · Clear Lake, IAN4538CSelby Gerald A · Sand Springs, OKN4538MHorner Edwin R · Howard, PAN45393Currie Grant · Hermosa Beach, CAN45395Holmgren Michael G · Kulm, ND
Back to AD 94-05-05 R1