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

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

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.

N4042VFreedom Aviation · Salina, KSBuilt 1948 · S/N 18361 N4043FFinley Trevor S · Caddo Mills, TXS/N 36943 N4043JDevine Steven A · Roseville, CAS/N 15065343 N4043UHawthorne Christopher J · Lafayette, LABuilt 1965 · S/N 15061443 N4043VThompson Frank · Weiser, IDBuilt 1948 · S/N 18362 N4044JLiberty University Inc · Lynchburg, VABuilt 1966 · S/N 15065344 N4044VStrnad William J · Taylors Falls, MNBuilt 1948 · S/N 18369 N4045EEwbank Martha C · Fairport, NYBuilt 1947 · S/N 11BC-133 N4045FRobinson Jeffrey A · Gaines, MIBuilt 1956 · S/N 36945 N4045UKnutson Tristian A · Spokane, WABuilt 1965 · S/N 15061445 N4046EKnutson Wayne R · Thompson, NDFirst renewal noticeBuilt 1947 · S/N 11BC135 N4046FVyatkin Denis · Sacramento, CAS/N 36946 N4046NLarrick Christopher J · Rhome, TXBuilt 1947 · S/N 13504 N4046UFox James E · Queen Creek, AZS/N 15061446 N4046VHowell Alvin M · Needville, TXS/N 18373 N4047FRegistration Pending · Sherwood, WIRegistration pendingBuilt 1958 · S/N 36947 N4047UDurfey Kyle A · Tucson, AZBuilt 1965 · S/N 15061447 N4048NMaas Timothy S · Elbert, COBuilt 1947 · S/N 13506 N4048UOshtemo Flyers LLC · Kalamazoo, MIBuilt 1965 · S/N 15061448 N4048VThomas Kevin C · Spokane, WABuilt 1948 · S/N 18377 N4049EWilcox Darrol A · Nenana, AKBuilt 1947 · S/N 11BC-137 N4049FSouthwell Arthur M · Arcadia, FLBuilt 1958 · S/N 36949 N4049JWashington Aero Club Inc · South Park, PAS/N 15065349 N4049UCatero Inc · Chickasha, OKBuilt 1965 · S/N 15061449 N4049VJustin William R · Sauk Rapids, MNBuilt 1975 · S/N 15076685 N404PCLegend Aire LLC · Mitchell, SDBuilt 2007 · S/N AL-1093 N404SSInternational Air Services Inc Trustee · Carson City, NVBuilt 1970 · S/N 0702 N4050FTitensor Shanelle Bn · Tetonia, IDS/N 36950 N4050VDussetschleger Lynn Albert · Luling, TXBuilt 1948 · S/N 18381 N4051FTamargo Victor · Fort Worth, TXBuilt 1958 · S/N 36951 N4051NSlayback Eric J · Florence, KYBuilt 1947 · S/N 13622 N4052NFrank Pfeifer & Son LLC · Bristow, NES/N 13871 N4053EMacveigh Craig A · New Carlisle, OHS/N 11BC-141 N4053USegura Jose · Chicago, ILBuilt 1965 · S/N 15061453 N4054VHunsberger Colin T · Palmer, AKBuilt 1948 · S/N 18386 N4055FFerguson Richard Trustee · Canyon Lake, TXBuilt 1958 · S/N 36955 N4055JStrobel Oliver K · Fishers, INBuilt 1966 · S/N 15065355 N4055UHanson Parry B · Eagle Creek, ORS/N 15061455 N4055VWayman Tim · Santa Rosa, CAS/N 18387 N4056FMullen Mark M · Livermore, CABuilt 1958 · S/N 36956 N4056NParinger Glenn R · Nashotah, WIBuilt 1947 · S/N 13514 N4056UFranklin Timothy · Brentwood, TNBuilt 1965 · S/N 15061456 N4057JTurner Jeremy A · Rancho Murieta, CABuilt 1966 · S/N 15065357 N40583Grald Jonathan A · New Hampton, NYS/N 15065358 N4059FDoss Lonny Richard · Lake Charles, LABuilt 1958 · S/N 36959 N405EWAnderson Liam K · Talkeetna, AKBuilt 2007 · S/N 001 N405JMGibson William · Aberdeen, MSS/N 17251766 N405MWWarin Michael R · Pella, IABuilt 1963 · S/N 17250433 N40605Richards William · Gardiner, NYBuilt 1941 · S/N 7350 N4060EValez Jay Daniel · North Branch, MNS/N 11BC-148

Back to AD 94-05-05 R1