Skip to content

Registered aircraft · 20,683

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N4335LClifford Gary G · Titusville, FLBuilt 1966 · S/N 17254404 N4336LWiff Robert A · Tahuya, WABuilt 1966 · S/N 17254406 N4337LWirt James · Goldsby, OKBuilt 1966 · S/N 17254408 N4337QHobart Aviation Inc · Akron, OHBuilt 1971 · S/N 17260237 N4338LInsco Kay · Martin, TNBuilt 1966 · S/N 17254409 N4338QRegistration Pending · Salisbury, NCRegistration pendingBuilt 1971 · S/N 17260238 N4338RThompson Group Inc · Stockton, CABuilt 1974 · S/N 17263091 N4339QC & K Aero LLC · La Valle, WIBuilt 1971 · S/N 17260239 N4339RBurke Brian · Westlake, OHBuilt 1974 · S/N 17263092 N433EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2014 · S/N 172S11455 N433FRKtoa Rentals LLC · Torrance, CABuilt 1997 · S/N 17280292 N433PTPilot Training Center LLC · Miami, FLBuilt 1974 · S/N 17263088 N433RMRocky Mountain College · Billings, MTBuilt 1974 · S/N 17262914 N433SPAspire Aviation LLC · Farmingdale, NYBuilt 1999 · S/N 172S8301 N4341LCut And Snip Flyers LLC · South Weber, UTBuilt 1966 · S/N 17254412 N4341ROleary Paul V · Gold Creek, MTBuilt 1974 · S/N 17263094 N4342LChenaille Lawrence A · Martinsville, INBuilt 1966 · S/N 17254413 N4343LDiamond C Aviation LLC · Gentry, ARBuilt 1966 · S/N 17254414 N4343QK M Air Enterprises Inc · Corona, CABuilt 1971 · S/N 17260243 N4343REndless Sky Aviation Inc · Syracuse, NYBuilt 1974 · S/N 17263096 N4344LTorbett William H Jr · Stockbridge, GABuilt 1966 · S/N 17254415 N4345QNeptune Aviation Services Inc DBA · Missoula, MTBuilt 1971 · S/N 17260245 N4346QCorrado Christian Blake · South Point, OHBuilt 1971 · S/N 17260246 N4346RFlyhnz LLC · Oxford, NCBuilt 1974 · S/N 17263097 N4347LChristiansen Steven P · Spokane, WAS/N 17254418 N4347RAvair LLC · Westville, INS/N 17265205 N43490Phillips Aviation LLC · Winnemucca, NVBuilt 1966 · S/N 17253653 N4349RVaughan James · Meansville, GABuilt 1974 · S/N 17263100 N434AHSkywest Leasing Inc · St George, UTBuilt 2014 · S/N 172S11456 N434EPNashville Flight School LLC · Nashville, TNBuilt 1998 · S/N 17280655 N434SPLlp Leasing Group LLC · Lewes, DEBuilt 1999 · S/N 172S8302 N4350RB2 West Corp · Winona, MNBuilt 1974 · S/N 17263101 N4351LWaggener James Franklin Jr · West Memphis, ARBuilt 1966 · S/N 17254424 N4351QJohnson James Benjamin · Rosharon, TXBuilt 1971 · S/N 17260251 N4351RVertol Systems Co Inc · Destin, FLBuilt 1974 · S/N 17263102 N4352RQuad City Area Flying Eagles · Milan, ILBuilt 1974 · S/N 17263103 N4353QHaley Paul M · Hillsboro, NHBuilt 1971 · S/N 17260253 N4355QSalcido Antonio Sr · Idaho Falls, IDS/N 17260255 N4358LMays John Anthony Sr · Cedar Hill, TXS/N 17254431 N4358RBig M Flying Club Inc · Aberdeen, WABuilt 1974 · S/N 17263109 N4359LKoschara Nathaniel L · Geneseo, NYBuilt 1966 · S/N 17254433 N4359QDollar Christopher S · Spring Hill, TNBuilt 1971 · S/N 17260259 N435CAWingsleasing LLC · Wichita, KSBuilt 2017 · S/N 172S12060 N435DRFriday Michael A · Noble, OKS/N 17250666 N435SPBoeing Employees Flying Association · Renton, WABuilt 1999 · S/N 172S8304 N4360QStoll Paul C · Blossom, TXBuilt 1971 · S/N 17260260 N4360RGrasshopper Flying Club Inc · Poughkeepsie, NYBuilt 1974 · S/N 17263111 N4361LFairbault Sky Club Inc · Waseca, MNBuilt 1966 · S/N 17254436 N4362QQuacker Holdings LLC · Aspen, COBuilt 1971 · S/N 17260262 N4362RBruther Thomas J · Temecula, CABuilt 1974 · S/N 17263113

Back to AD 90-06-03 R1