Skip to content

Registered aircraft · 2,376

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:82-06-11-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:82-06-11-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:82-06-11-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:82-06-11-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:82-06-11-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:82-06-11-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.

N83047Gullo Michael · Voorhees, NJS/N 28R-8131038 N8304NSmith Steven Thomas · Gosnell, ARBuilt 1980 · S/N 28R-8118033 N8307LStraight Arrow LLC · Chicago, ILS/N 28R-8118034 N830PCSprowl Brian M · Millville, NJS/N 28R-7335055 N8313RCardinal Flyers Inc · Stuart, FLBuilt 1980 · S/N 28R-8118041 N8315BRobins Air Force Base Aero Club · Robins Afb, GABuilt 1980 · S/N 28R-8118037 N8315SMagneto Consulting LLC · Grayslake, ILBuilt 1980 · S/N 28R-8131044 N83164Mavity Michael D · Phoenix, AZBuilt 1980 · S/N 28R-8131051 N83196Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 28R-8118045 N8320EFerber Michael M · Parker, COBuilt 1980 · S/N 28R-8131056 N8320HBlue Oasis Flight Support · Tamarac, FLBuilt 1980 · S/N 28R-8131057 N8321CJackson Blane · Beaufort, NCBuilt 1975 · S/N 28R-7635147 N8321XPiper Investments · Visalia, CABuilt 1980 · S/N 28R-8131060 N83225Wiser Air LLC · Eastchester, NYBuilt 1982 · S/N 28R-8331007 N83236Wojno Kirk J Md · Clinton Township, MIBuilt 1981 · S/N 28R-8118050 N8325CPecile Nicola · Lancaster, CABuilt 1983 · S/N 28R-8331041 N8327BJet & Rotor Aviation LLC · Sacramento, CAS/N 28R-8131071 N8327HR Darrell Weaver Enterprises LLC · Moore, OKBuilt 1980 · S/N 28R-8131072 N832FCFlycarolina LLC · Concord, NCBuilt 1981 · S/N 28R-8118051 N832JAMoore Jimmy L · Beach City, TXBuilt 1979 · S/N 28R7931187 N8332BBeckham Brett A · Anson, TXBuilt 1980 · S/N 28R-8031088 N8332CKyro Kevin D · Lakeville, MNS/N 28R-7635148 N8332YShepard Jeffrey · Roanoke, TXS/N 28R-8131075 N8335XKenyon Travis · Phoenix, AZBuilt 1982 · S/N 28R-8331013 N8342CBennett Donald B · Birmingham, ALBuilt 1976 · S/N 28R-7635149 N83484Doumit Patrick F · Cathlamet, WAS/N 28R-8131097 N83486Arrow Aviation LLC · Scottsdale, AZBuilt 1981 · S/N 28R-8131098 N8353COstwinkle Jeffrey J · Justin, TXBuilt 1976 · S/N 28R-7635152 N8359ESabrilyn Ventures LLC · The Villages, FLBuilt 1981 · S/N 28R-8131099 N8364VRodgers Keith E · Dover, PAS/N 28R-8118061 N83685Hennen Roger · Sanger, TXS/N 28R-8118046 N83734Willis Jason W · North Bend, OHS/N 28R-8131118 N83762Lansing Community College · Mason, MIBuilt 1981 · S/N 28R-8118065 N8378BMathewson Leslie A · Knoxville, TNBuilt 1981 · S/N 28R-8118042 N8382CSwickert Donald L II · Merritt Island, FLBuilt 1976 · S/N 28R-7635154 N8382TPhoreman James Jr · Lancaster, CABuilt 1981 · S/N 28R-8118068 N8383STrend Vector Aviation International Inc · Barrigada, GUS/N 28R8118044 N8392TJ & L Flight Ventures LLC · Edgewater, MDBuilt 1981 · S/N 28R-8131140 N8392VSaunders Robert · Alpharetta, GABuilt 1981 · S/N 28R-8131141 N83956Mc Laughlin Paul E · Mansfield, OHBuilt 1981 · S/N 28R-8131142 N8395YMacair Aviation LLC · Xenia, OHBuilt 1981 · S/N 28R-8118072 N8397CParker Edward M Jr DBA · Griffin, GABuilt 1976 · S/N 28R-7635156 N8398HAircom Mechanical · Milpitas, CABuilt 1981 · S/N 28R-8131144 N839JCGng LLC · New Market, ALBuilt 1973 · S/N 28R-7335193 N83EDRolando Pierluigi · San Marcos, CABuilt 1979 · S/N 28R-7931279 N84008Harkey Wesley · Sherrills Ford, NCBuilt 1981 · S/N 28R-8131145 N8404CLudwick Paul W · Lighthouse Point, FLBuilt 1976 · S/N 28R-7635157 N8406TCook Neal L · Anchorage, AKBuilt 1981 · S/N 28R-8131161 N840CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 2844182 N8412BPlane Fun Inc Tr Trustee · Snellville, GABuilt 1981 · S/N 28R-8131164

Back to AD 82-06-11 R1