Skip to content

Registered aircraft · 2,375

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.

N54412Flight Time Builders Inc · Memphis, TNBuilt 1973 · S/N 28R-7435098 N54414Panjab Aviation Inc · Las Vegas, NVS/N 28R-7435101 N5442TMckinney Christopher W · Queensbury, NYBuilt 1972 · S/N 28R-7235232 N54473Gomez Julian E · Palo Alto, CAFirst renewal noticeBuilt 1973 · S/N 28R-7435110 N54485Schrock Paul · Mooresville, NCBuilt 1973 · S/N 28R-7435112 N545WRCumulus Aviation Services LLC · Port Orange, FLBuilt 1972 · S/N 28R-7235119 N5472TAdvantage Aviation Inc · Palo Alto, CABuilt 1972 · S/N 28R-7235234 N547BWBland Gregory A · Florence, KYBuilt 1974 · S/N 28R-7435217 N548JMLarock Guy · New Bedford, MABuilt 1979 · S/N 28R7931018 N5495THill Mark D · Magnolia, TXS/N 28R-7235236 N55005Butler Joseph E · Somers, CTBuilt 1973 · S/N 28R-7335167 N55023Charron William H · Burwell, NEBuilt 1973 · S/N 28R-7335168 N55030Reiner John G · Wakefield, MIBuilt 1973 · S/N 28R-7335171 N55058Eggensberger Edmund G · Simpsonville, SCS/N 28R-7335174 N55069Tre Aviation Corp · Wilmington, DEBuilt 1973 · S/N 28R-7335177 N55088Slipstream Aviation LLC · Calera, ALBuilt 1973 · S/N 28R-7335178 N5508VDelaney John J · Cottonwood, CAS/N 28R-7703129 N55116Stick And Rudder Aviation LLC · Hale, MOBuilt 1973 · S/N 28R-7335182 N55131Sansone Gary A · Fort Laramie, WYBuilt 1973 · S/N 28R-7335184 N55154Kanpahem Aviation LLC · Hawkins, TXBuilt 1973 · S/N 28R-7335187 N55176Hall Davis · Mobile, ALBuilt 1973 · S/N 28R-7335189 N55177Saunders Ivan J · Margate, FLBuilt 1973 · S/N 28R-7335190 N55189Cole Randall J · Pace, FLS/N 28R-7335192 N551DKTarrow Group LLC · Thompsons Station, TNBuilt 1978 · S/N 28R-7803279 N55220Ishii Kanji · Brooklyn, NYBuilt 1973 · S/N 28R-7335195 N55247Nordstrom Terry G · Scottsdale, AZBuilt 1973 · S/N 28R-7335199 N55253Mccall Christopher J · Cocoa Beach, FLBuilt 1973 · S/N 28R-7335200 N55275Bas Part Sales LLC · Greeley, COBuilt 1973 · S/N 28R-7335209 N55287Prairie Winds Aviation LLC · Overland Park, KSBuilt 1973 · S/N 28R-7335210 N55306R & R Flying LLC · Miami, FLBuilt 1973 · S/N 28R-7335212 N55317Schwader Aviation LLC · Saint Joseph, MOBuilt 1973 · S/N 28R-7335214 N55319Guckin Michael E · The Villages, FLBuilt 1973 · S/N 28R-7335215 N55330Eaw Aviation LLC · Middletown, MDBuilt 1973 · S/N 28R-7335218 N55345Arrow Flite LLC · Chino Hills, CABuilt 1973 · S/N 28R-7335220 N55359Uribe Roberto · Houston, TXBuilt 1973 · S/N 28R-7335222 N55423Prescott Flying Club Inc · South Saint Paul, MNBuilt 1973 · S/N 28R-7335231 N5545BLundsted Andrew S · Taylor Falls, MNBuilt 1973 · S/N 28R-7335236 N55460Nish Aviation LLC · Concord, NCBuilt 1973 · S/N 28R-7335237 N55484Yoder Sylvan R · Camilla, GABuilt 1973 · S/N 28R-7335241 N55485Cross Gary DBA · Commerce Twp, MIBuilt 1973 · S/N 28R-7335242 N55516On Glideslope LLC · Middletown, DEBuilt 1973 · S/N 28R-7335247 N55533Gw Aero LLC · Ponte Vedra Beach, FLBuilt 1973 · S/N 28R-7335249 N55566Speck G Dan · Roaring Spring, PABuilt 1973 · S/N 28R-7335252 N55599Manning Holdings LLC · Portland, ORBuilt 1973 · S/N 28R-7335256 N555BECrocker William D · Toledo, WABuilt 1973 · S/N 28R-7335254 N555KLShemenski Aaron J · Tiverton, RIBuilt 1974 · S/N 28R-7535044 N555TCArchibeque Christopher James · Albuquerque, NMBuilt 1977 · S/N 28R-7703061 N55610Luxury Aviation LLC · Butler, PABuilt 1973 · S/N 28R-7335258 N55628Ag Air Squadron Two LLC · Saint Joseph, ILBuilt 1973 · S/N 28R-7335261 N55641Gizzy LLC · Fish Creek, WIBuilt 1973 · S/N 28R-7335263

Back to AD 82-06-11 R1