Skip to content

Registered aircraft · 8,920

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:85-02-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:85-02-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:85-02-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:85-02-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:85-02-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:85-02-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.

N7771YDakota Executive Flight Inc · Miller, SDBuilt 1965 · S/N 30-857 N7773PJenkins John R · Fairmont, WVBuilt 1962 · S/N 24-2989 N7773YBismuth Robert · Seattle, WABuilt 1965 · S/N 30-859 N7774YReed John · Seattle, WABuilt 1965 · S/N 30-860 N7776PHardin Gerald A · Port Clinton, OHFirst renewal noticeBuilt 1962 · S/N 24-2993 N7777KMoss Conrad C · South Pittsburg, TNBuilt 1950 · S/N 22-2 N7777PWeihe Philip D · Cleveland Heights, OHBuilt 1961 · S/N 24-2994 N7777YDigati Anthony J · Mentone, CAS/N 30-863 N7778YSpiegel Eitan · San Francisco, CABuilt 1965 · S/N 30-864 N7778ZIglehart Stephen R · Bismarck, NDBuilt 1966 · S/N 25-3977 N7779YMccool Kenneth W · Olive Branch, MSBuilt 1965 · S/N 30-865 N777BBMrnak Andy M · Bowman, NDBuilt 1961 · S/N 24-2227 N777DFOl Hughes LLC · Staplehurst, NEBuilt 1972 · S/N 24-5019 N777EEDga Aviation LLC · Sacramento, CABuilt 1961 · S/N 24-2773 N777FSCasey William F · Ponderay, IDBuilt 1972 · S/N 39-121 N777KGLonnevik Dennis F · Bigfork, MTBuilt 1966 · S/N 30-1159 N777KPKelly'S Flying Service LLC · Warrensburg, MOBuilt 1963 · S/N 30-110 N777MURobinson James G · Baltimore, MDBuilt 1964 · S/N 26-83 N777RHLarson Peter T Trustee · Coraopolis, PABuilt 1965 · S/N 30-908 N777ZZMiller Jordan Raul · Columbus, OHFirst renewal noticeS/N 24-1495 N7780PMolinari Eugene A Jr · Milton, FLBuilt 1961 · S/N 24-2997 N7781KEvans Thomas Sidney · Wilmer, ALBuilt 1951 · S/N 20-607 N7781PBallard William S · Sanford, NCBuilt 1962 · S/N 24-2998 N7781ZBrandywine Soaring Association · Hockessin, DEBuilt 1966 · S/N 25-3983 N7785ZAerial Banners Inc · Pembroke Pines, FLBuilt 1966 · S/N 25-3989 N7786POlson Arthur W · Fairbanks, AKBuilt 1962 · S/N 24-3003 N7786YBell Frank · Tuxedo, NCBuilt 1965 · S/N 30-869 N7787YBucks Flight Academy LLC · Cashion, OKBuilt 1965 · S/N 30-870 N7788KEaves Charles W · Salt Lake City, UTFirst renewal noticeBuilt 1951 · S/N 20-611 N7788PEight Eight Papa Inc · Williamsport, PABuilt 1962 · S/N 24-3005 N7790YMaki Stephen B · New Port Richey, FLBuilt 1965 · S/N 30-146 N7791YMaki Stephen B · New Port Richey, FLBuilt 1965 · S/N 30-874 N7792PAdkins Brian Keith · Twp Washinton, NJBuilt 1962 · S/N 24-3009 N7793KBates Charles A Sr · Vernon, NYBuilt 1951 · S/N 20-620 N7793YRedinger Aaron · Hanlontown, IABuilt 1965 · S/N 30-876 N7794KPockrus Pat B · Mineral Wells, TXBuilt 1951 · S/N 20-623 N7794PWard Ronald Kevin · Santa Rosa, CAS/N 24-3011 N7795PBressman John W · Belton, MOBuilt 1962 · S/N 24-3012 N7796KHenley Steven F · Athens, GAS/N 20-596 N7796PDsr Cherokee 180 LLC · Dallas, TXBuilt 1962 · S/N 24-3014 N7797KScootair LLC · Alburgh, VTBuilt 1951 · S/N 20-614 N7797PGrassi Michael A · Waterford, MIBuilt 1963 · S/N 24-3015 N7797ZMiller Andy D · Marana, AZS/N 25-3999 N7799KPatterson John S · Edgemont, ARBuilt 1951 · S/N 20-628 N7799ZMid Atlantic Soaring Association · Frederick, MDBuilt 1966 · S/N 25-4002 N779MRRock N Robins Flying Service LLC · Palm City, FLBuilt 1976 · S/N 27-7654047 N77CHTcb Management Inc · Chiefland, FLBuilt 1971 · S/N 39-136 N77GParker Ray W · Nome, AKS/N 22-1210 N77KKMensch Aviation LLC · Hastings, MIBuilt 1980 · S/N 278154002 N77KTRochna Stephen J · Fallon, NVBuilt 1958 · S/N 23-1306

Back to AD 85-02-05 R1