Skip to content

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.

N80567Barnett Paul S · Brookhaven, MSBuilt 1946 · S/N 70 N80569Samuelian Stephen P · Tehachapi, CAS/N 72 N8056LJenkins Mark · Santa Clarita, CABuilt 1967 · S/N 17256256 N8056XKerekes John J · Tucson, AZBuilt 1961 · S/N 17248556 N80570Hoffman Richard A · Scottsdale, AZBuilt 1946 · S/N 73 N80573Holliday Mark E · Lake Elmo, MNBuilt 1946 · S/N 76 N80576Putnam George Milton Sidney · Anchorage, AKS/N 79 N8057AP P & J LLC · Gillette, WYBuilt 1952 · S/N 20909 N8057FThenappan Nachiappan · Round Rock, TXBuilt 1966 · S/N 15064157 N8057LSale Reported · Kirksville, MOSale reportedBuilt 1967 · S/N 17256257 N8057UNantz William G · Raleigh, NCS/N 15077882 N8058BBreisch Frederick A Jr · Findlay, OHBuilt 1957 · S/N 29858 N8058USafer Jonathan · West Milford, NJBuilt 1976 · S/N 15077883 N80591Lakala Aviation Inc · Vicksburg, MIS/N 94 N8059CRichard David L · Wilton, MES/N 18-4440 N805BMast Henry V · Dayton, TXBuilt 1950 · S/N 6735 N805JKKoons John D · Waterville, MEBuilt 2019 · S/N 805 N80600Gores Thomas J · Franklin, WIBuilt 1946 · S/N 1005 N8060LOneonone Flight Training LLC · Hagerstown, MDS/N 17256260 N8060SGrinfeder Alex J · Little Rock, ARBuilt 1965 · S/N 15061660 N8061Gibson Isaac S · Saint John, INBuilt 1965 · S/N 15061669 N80611Marrs Aircraft Repair Recovery Sales LLC · Lake Placid, FLBuilt 1946 · S/N 1016 N80613Finnegan Aviation Services LLC · Cary, ILBuilt 1946 · S/N 1018 N80614Jenkins Susan · Pima, AZBuilt 1946 · S/N 1019 N80615Permian Basin Blue Sky Medical Supply Inc · Odessa, TXS/N 1020 N8061BUrioste Zachary Ty Fred · Fort Collins, COBuilt 1957 · S/N 29861 N8061FMorales Jose · Mission, TXBuilt 1966 · S/N 15064161 N8061LColeman Terrence C · Maryville, TNBuilt 1967 · S/N 17256261 N8061XSteck Phillip G · Smartsville, CAS/N 17248561 N80622Lam Lawrence Y · Rosemead, CABuilt 1946 · S/N 1027 N8062BPalmer Felix E Jr · Murphy, NCBuilt 1957 · S/N 29862 N8062FJackson Hugh W · Cordova, SCBuilt 1966 · S/N 15064162 N8062SSturm Steve G Trustee · Springdale, ARS/N 15061662 N8062XHerring Fred A · Walnut Ridge, ARBuilt 1961 · S/N 17248562 N80630Green David J · Beaufort, SCBuilt 1946 · S/N 1035 N80637Brown Bear Haven LLC · Anchorage, AKBuilt 1946 · S/N 1042 N8063ACarleton Jeffrey S · Palmer, AKBuilt 1952 · S/N 20915 N8063SCole Stephen C · Lexington, KYBuilt 2003 · S/N 122326 N80644Mccarty Keith · Huntsville, TXBuilt 1946 · S/N 1049 N80647Cc Motors LLC · Redding, CABuilt 1946 · S/N 1052 N80649Red Arrow Aviation LLC · Santa Teresa, NMBuilt 1946 · S/N 1054 N8064BCarrison Harold F · Pleasanton, CABuilt 1957 · S/N 29864 N8064LMccormick Michael P · Durham, NCBuilt 1967 · S/N 17256264 N8064TThomas Raymond · Deer Park, WAS/N 56764 N80654Peacock Robert E · Cochran, GABuilt 1946 · S/N 1059 N80658Stalker Allen R Sr · New Marlborough, MABuilt 1946 · S/N 1063 N8065LDream Big Aviation LLC · Mount Juliet, TNS/N 17256265 N8065TDefalco James B · Simi Valley, CABuilt 1960 · S/N 56765 N8065XCollege Of Missionary Aviation Inc · Keystone Heights, FLBuilt 1961 · S/N 17248565 N8066FWilson Edwin · Midland, MIBuilt 1966 · S/N 15064166

Back to AD 94-05-05 R1