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

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.

N7841TMannon Jason L · Fontana, WIBuilt 1960 · S/N 47441 N7841ULiles Edward N · Siler City, NCBuilt 1964 · S/N 17251841 N7841XKleczkowski Aaron · Santa Rosa, CAS/N 17248341 N78420Piercy Ronald S · Moses Lake, WABuilt 1947 · S/N 23159 N78425Cragg Gordon E · Georgetown, TXBuilt 1947 · S/N 23166 N78427Bartlett Donald R · Weirsdale, FLBuilt 1947 · S/N 23168 N7842EErkert Matthew P · Lebanon, PAS/N 17642 N7842TRmb Helicopters LLC · Factoryville, PABuilt 1960 · S/N 47442 N7842USelig Benjamin L · Arlington, VAS/N 17251842 N7843FDas Manoj Kumar · Buffalo Grove, ILBuilt 1966 · S/N 15063943 N7843UHarkrader Aviation LLC · Louisa, VABuilt 1964 · S/N 17251843 N7843XEpidendio Peter W · Lakeport, CABuilt 1961 · S/N 17248343 N7844FWise Jonathan Keith · Eden, NCS/N 15063944 N7844TRegistration Pending · Saint Matthews, SCRegistration pendingBuilt 1960 · S/N 47444 N7844URegistration Pending · Hereford, AZRegistration pendingBuilt 1964 · S/N 17251844 N7844XFeather Farms Inc · Griffithville, ARBuilt 1961 · S/N 17248344 N7845EWallace Terry E · Bedford, TXBuilt 1959 · S/N 17645 N7845TOrr Dorthy L · Santa Paula, CABuilt 1960 · S/N 47445 N7846FGrossman Steven · Seven Valleys, PAS/N 15063946 N7846UCrisco Millwright Services LLC · Lewes, DEBuilt 1964 · S/N 17251846 N7847UFinnegan James M · West Valley City, UTBuilt 1964 · S/N 17251847 N7847XNix Charles W · San Jose, CABuilt 1961 · S/N 17248347 N7849EDelaney Jerard Emmet II · Monroe, MIBuilt 1959 · S/N 17649 N7849TMyers Stanley · Portland, ORBuilt 1960 · S/N 47449 N7849ZMorgan Gregory A · Rice, VABuilt 1963 · S/N 15059949 N7850UJohnson Lawrence F · Sacramento, CABuilt 1964 · S/N 17251850 N7850ZBenscoter Richard S · Nordman, IDBuilt 1963 · S/N 15059950 N7851FDevries James E · Bejou, MNBuilt 1966 · S/N 15063951 N7851UR & S Aviation LLC · Corning, ARBuilt 1964 · S/N 17251851 N7852UMartinson James C · Sioux Falls, SDBuilt 1964 · S/N 17251852 N7852ZKvservices LLC · Buckley, WABuilt 1963 · S/N 15059952 N78539Koinzan Steven D · Valentine, NEBuilt 1947 · S/N 111355 N7853EFelton Marion L · Dickens, IARevoked, canceledBuilt 1959 · S/N 17653 N7853FEdwards Michael J · Hazlehurst, GABuilt 1966 · S/N 15063953 N7853TBailey Ned A · Friday Harbor, WABuilt 1960 · S/N 47453 N7854ZAdams Jerry W · Dallas, TXBuilt 1963 · S/N 15059954 N7855FSmith Joshua B · Kenai, AKS/N 15063955 N7855XBensema Amber L · Winchester, CAS/N 17248355 N7856CSanders Dusty A · Slaton, TXBuilt 1946 · S/N 9224 N7856FFitzgibbon Patrick D · Waterloo, WIBuilt 1966 · S/N 15063956 N7856XBrown Daniel F · Belgrade, MTBuilt 1961 · S/N 17248356 N7857ELout James Mike · Jasper, TXBuilt 1959 · S/N 17657 N7857TDiamondhead Aero Co-Owners LLC · Picayune, MSBuilt 1960 · S/N 47457 N7857UMok Kuch · Delano, CABuilt 1964 · S/N 17251857 N78580Ferley Shane M · Goddard, KSBuilt 1947 · S/N 111373 N7858EWhite Larry K · Pittsburgh, PABuilt 1959 · S/N 17658 N7858FShelley Tiffany · Chandler, AZFirst renewal noticeS/N 15063958 N7859UDuncan Martin R · Newark, ARBuilt 1964 · S/N 17251859 N7859XGraves David E · Astoria, ORS/N 17248359 N78605Tuffli David L · Hillsboro, ORBuilt 1947 · S/N 11-1364

Back to AD 94-05-05 R1