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.

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 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 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 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 N55652A Group Inc · Houston, TXBuilt 1973 · S/N 28R-7335266 N55660Cifuentes Julio · Naples, FLS/N 28R-7335268 N55677Arrow II Aviation LLC · Rocky Mount, NCBuilt 1973 · S/N 28R-7335270 N55678Murdick Robert A II · Bluemont, VABuilt 1973 · S/N 28R-7335271 N55695Straight Arrow Aviation LLC · Aurora, ILBuilt 1973 · S/N 28R-7335273 N55696Walla Walla University · College Place, WABuilt 1973 · S/N 28R-7335274 N55699Hill Caleb · Indianapolis, INBuilt 1973 · S/N 28R-7335281 N55700Curry Edwin A · Pearland, TXBuilt 1973 · S/N 28R-7335279 N55711To Ivan K · Auburndale, FLS/N 28R-7335276 N55726Diedeman Thomas A · Lake City, FLBuilt 1973 · S/N 28R-7335278 N55756Piper Aircraft Inc · Vero Beach, FLBuilt 1973 · S/N 28R-7335267 N55763Walker William L · Norfolk, MABuilt 1973 · S/N 28R-7335283 N55786Calkins Mark · Nikiski, AKBuilt 1973 · S/N 28R-7335288

Back to AD 81-11-02 R1