Skip to content

Registered aircraft · 87

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:76-18-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-18-06') 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:76-18-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-18-06')
  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:76-18-06')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-18-06')
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.

N108UCHot Springs Flyers Inc · Covington, LABuilt 1979 · S/N 31T-8020018 N111JFJoyce Aviation Inc · Winston Salem, NCBuilt 1981 · S/N 31T8120012 N115BMAshland Water Group · Ashland, OHBuilt 1982 · S/N 31T-8120053 N115PCDodson International Parts Inc · Pelkie, MIBuilt 1977 · S/N 31T-7820001 N1183GC A R Lease Corp · Brentwood, TNBuilt 1979 · S/N 31T-7920086 N118WCHalair Inc · Diablo, CABuilt 1979 · S/N 31T-8020020 N131PCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1977 · S/N 31T-7820009 N139CSCheyenne Flight Group LLC · Wallingford, CTS/N 31T-8120004 N14TNGonzalez-Ruiz Antonio R · Mountain Brk, ALBuilt 1981 · S/N 31T-8120060 N154CAFedair Inc · Indianapolis, INBuilt 1980 · S/N 31T-8020085 N155MCWhite Bay Aviation LLC · Corpus Christi, TXBuilt 1978 · S/N 31T-7820069 N171JPCentral Virginia Aviation Inc · North Dinwiddie, VAS/N 31T-7720028 N178SGTango Tango LLC · Naples, FLS/N 31T-8020044 N181DCAlliance Air Parts Acquisitions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedS/N 31T-7520026 N186GADavis Aviation Inc DBA · Brandon, MSS/N 31T-7820086 N195AAAir Travel Management LLC · Lemont Furnace, PABuilt 1978 · S/N 31T7904001 N1976JLock Haven Aircraft Sales · Lock Haven, PABuilt 1974 · S/N 31T-7520005 N200PGPanther Enterprises LLC · Fort Myers, FLBuilt 1979 · S/N 31T-7920015 N20WLSch Aviation Inc Trustee · Sporle Kings LynnBuilt 1976 · S/N 31T-7720011 N227TMMed Care Inc · Grand Island, NES/N 31T-7400008 N22AWAir What What LLC · Clackamas, ORBuilt 1979 · S/N 31T-7920059 N22WFBemidji Aviation Services Inc · Bemidji, MNBuilt 1978 · S/N 31T-7920007 N233PSDodson International Parts Inc · Rantoul, KSBuilt 1978 · S/N 31T-7820039 N284SBWestwind Inc · Liberal, KSS/N 31T-7820074 N28BGKapowsin Air Sports Ltd · Shelton, WABuilt 1976 · S/N 31T-7720005 N294ZPCumulus Aviation Inc Trustee · Wilmington, DEBuilt 1980 · S/N 31T-8020063 N302TAMidwest Flying Service LLC · Wilmington, DEBuilt 1980 · S/N 31T-8020046 N30DUHtf Aviation LLC · Kalispell, MTS/N 31T-7720054 N324ARParrish Blake · Seminole, TXS/N 31T-7620052 N333XXArnot Robert · Stowe, VTS/N 31T-7920038 N336PN336p LLC · Williamstown, NJBuilt 1974 · S/N 31T-7400003 N390JDSevern Aeronautics Ltd · Annapolis, MDBuilt 1978 · S/N 31T-7820061 N396JHGoode Todd · Nampa, IDS/N 31T-7920087 N39EHAir Travel Management Of Delaware LLC · Wilmington, DEBuilt 1978 · S/N 31T-7920020 N400CMAerial Surveys International LLC · Watkins, COBuilt 1976 · S/N 31T-7620040 N406RSAero South Florida Inc · Deerfield Beach, FLBuilt 1979 · S/N 31T-7920048 N40TTHeiderscheidt Aerial LLC · Sleepy Eye, MNBuilt 1975 · S/N 31T-7520023 N427DDYunus Asim · Saginaw, MIBuilt 1978 · S/N 31T-7820029 N427TAAircraft Properties LLC · Hampstead, NCBuilt 1977 · S/N 31T-7720027 N43WHLaurel Malibu LLC · Windber, PABuilt 1982 · S/N 31T-8120068 N444PCValiair Limited Company Trustee · Casper, WYBuilt 1979 · S/N 31T-7920066 N444RCTiffin Aire Inc · Tiffin, OHBuilt 1975 · S/N 31T-7520030 N455MMMiklus Enterprises LLC · Middletown, DEBuilt 1980 · S/N 31T-8020087 N473GGTiffin Aire Inc · Tiffin, OHS/N 31T-7820026 N47JFReeve Howard E · Minot, NDS/N 31T-8020031 N497WWWin Win Aviation Inc · Wake Forest, NCBuilt 1978 · S/N 31T-7820045 N521PMJetset Airmotive Inc · Hialeah, FLBuilt 1977 · S/N 31T-7720048 N524AMSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 31T7920039 N525SWKramme Scott R · Elmer, NJBuilt 1979 · S/N 31T-8020024 N528CHWord Jon D · Albuquerque, NMBuilt 1980 · S/N 31T-8020049

Back to AD 76-18-06