Skip to content

Registered aircraft · 1,753

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:81-11-02-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:81-11-02-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:81-11-02-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:81-11-02-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:81-11-02-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:81-11-02-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.

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 N83196Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 28R-8118045 N8321CJackson Blane · Beaufort, NCBuilt 1975 · S/N 28R-7635147 N83236Wojno Kirk J Md · Clinton Township, MIBuilt 1981 · S/N 28R-8118050 N832FCFlycarolina LLC · Concord, NCBuilt 1981 · S/N 28R-8118051 N8332CKyro Kevin D · Lakeville, MNS/N 28R-7635148 N8342CBennett Donald B · Birmingham, ALBuilt 1976 · S/N 28R-7635149 N8353COstwinkle Jeffrey J · Justin, TXBuilt 1976 · S/N 28R-7635152 N8364VRodgers Keith E · Dover, PAS/N 28R-8118061 N83685Hennen Roger · Sanger, TXS/N 28R-8118046 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 N8395YMacair Aviation LLC · Xenia, OHBuilt 1981 · S/N 28R-8118072 N8397CParker Edward M Jr DBA · Griffin, GABuilt 1976 · S/N 28R-7635156 N839JCGng LLC · New Market, ALBuilt 1973 · S/N 28R-7335193 N8404CLudwick Paul W · Lighthouse Point, FLBuilt 1976 · S/N 28R-7635157 N840CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 2844182 N8413CBrown Lawrence L · Millington, TNBuilt 1976 · S/N 28R-7635159 N8414CInternational Flying Club Inc · Winfield, ILBuilt 1976 · S/N 28R-7635160 N8422MDymond Mark S · Monterey, TNBuilt 1975 · S/N 28R-7535225 N849BTPeacock Group LLC · Clermont, FLBuilt 1974 · S/N 28R-7535095 N84ARArc Aviation LLC · Auburn, ALBuilt 1977 · S/N 28R-7737099 N8508CHobart Aviation Inc · Akron, OHBuilt 1976 · S/N 28R-7635164 N850NCRegistered aircraftBuilt 2002 · S/N 2844074 N8564NEby Leo V · Clearville, PAS/N 28R-7135112 N8582CCurran Aviation Services LLC · Yorba Linda, CABuilt 1976 · S/N 28R-7635166 N8582MSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2016 · S/N 2844160 N8583NSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2016 · S/N 2844161 N8584TSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2016 · S/N 2844162 N8585ZSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2016 · S/N 2844163 N8586ASkyborne Airline Academy Inc · Vero Beach, FLBuilt 2016 · S/N 2844164 N8587KSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2016 · S/N 2844165 N8596NLsg Flying Services LLC · Sarasota, FLBuilt 1971 · S/N 28R-7135129 N8606EJ&H Aviation LLC · Middletown, DEBuilt 1976 · S/N 28R-7635191 N8610NSkipper Donald J · Huntersville, NCBuilt 1971 · S/N 28R-7135131 N8647NVossberg Carl A · Umatilla, FLBuilt 1971 · S/N 28R-7135128 N8650NAllen Flight Service LLC · Laredo, TXBuilt 1971 · S/N 28R-7135106 N8651CDoby Julian · Graham, NCBuilt 1976 · S/N 28R-7635170 N8651ESchoen Michael · Lakeville, MNBuilt 1976 · S/N 28R-7635193 N8667CWaldrops Auto Parts Inc · Taft, CABuilt 1976 · S/N 28R-7635177 N8669CB R S Leasing Inc · Wilmington, DEBuilt 1976 · S/N 28R-7635178 N8680EGibson Kevin S · Porterville, CABuilt 1976 · S/N 28R-7635194 N8684EMotl Gregory C · Humble, TXBuilt 1976 · S/N 28R-7635195

Back to AD 81-11-02 R1