Skip to content

Registered aircraft · 47,133

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:2000-23-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21') 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:2000-23-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
  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:2000-23-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
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.

N427SRTrosclair Air LLC · Gonzales, LABuilt 2007 · S/N 2432 N427TCag Farms Inc · Angier, NCBuilt 1963 · S/N D-7232 N427TXMayfly Holdings LLC · Monticello, FLBuilt 2008 · S/N 421007 N427VKNichols Vikki J · Williamson, GABuilt 1967 · S/N 337M0133 N427WYMayes Neil M · Lovell, WYBuilt 1978 · S/N 18266557 N427YECavu Capital LLC · Concord, NCBuilt 2013 · S/N 0500 N42800Asbury William J · Fresno, CABuilt 1976 · S/N D-9934 N42801Aas LLC · Ovid, MIBuilt 1968 · S/N 18259195 N42804N42804 LLC · Brush, COBuilt 1968 · S/N 18259196 N4280QHines Thomas J · Amsterdam, NYBuilt 1973 · S/N 18502230 N4280SYoung Daniel R · Germantown, TNBuilt 1976 · S/N D-9969 N42818Cleveland Jeffrey Allen Trustee · Indian Trail, NCBuilt 1968 · S/N 18259203 N42820Cordobesa Aviation LLC · Belgrade, MTBuilt 1968 · S/N 18259204 N42823Acs Products Co · Lake Havasu City, AZBuilt 1968 · S/N 18259205 N42826Aero Elite Inc · Wilmington, DEBuilt 1968 · S/N 18259208 N4282PAero Tramp Holdings LLC · Dallas, TXBuilt 1999 · S/N E-3282 N4282SGoerzen John P · Goessel, KSBuilt 1976 · S/N E-946 N42831Shuff James S II · Victor, WVBuilt 1968 · S/N 18259209 N42849Moonrise Soaring Inc · Wilmington, DEBuilt 1968 · S/N 18259213 N4284KHornblower Paul S · Chilmark, MABuilt 1948 · S/N NAV-4-1284 N42850Ogren Craig R · Berlin, CTBuilt 2010 · S/N 2678081 N42851Emmons Steven · Russellville, ARBuilt 1968 · S/N 18259214 N42852Fisch Kurt D · Riverside, CABuilt 1968 · S/N 18259215 N42855Wojteczko Jason A · Derby, KSS/N 18259216 N42865Skylane Partners LLC · Duvall, WABuilt 1968 · S/N 18259224 N42871Registered aircraftBuilt 1968 · S/N 18259226 N42874Kloker Daniel E · Owasso, OKBuilt 1968 · S/N 18259227 N42875Bowes Tyler D · Fremont, OHBuilt 1968 · S/N 18259228 N42876Norcal Flight Center LLC · Lincoln, CABuilt 1968 · S/N 18259229 N42877Allain Patrick C · Brusly, LABuilt 1968 · S/N 18259230 N4287AWilliam Dolson And Associates LLC · Santa Fe, NMBuilt 1980 · S/N 340A1010 N4287SLemanski Joseph S · Fiskdale, MABuilt 1977 · S/N TC-2112 N42887Bratlien Michael D · Aurora, COBuilt 1968 · S/N 18259234 N42888Ahigian Craig S · Laguna Niguel, CABuilt 1968 · S/N 18259235 N42889Fuller Lawrence A · Wasilla, AKBuilt 1973 · S/N 18052382 N4288PMooradian Edward M · Fowler, CABuilt 1968 · S/N 18259194 N42893Registration Pending · El Paso, TXRegistration pendingBuilt 1968 · S/N 18259239 N42894Comal Aero Inc · Schertz, TXBuilt 1968 · S/N 18259240 N42898Perera Austin L · Barnstable, MABuilt 1968 · S/N 18259242 N42899Smith Charles Max · Canon City, COBuilt 1968 · S/N 18259243 N428AJetpropmontana LLC · Cameron, MTBuilt 1986 · S/N 4608031 N428AKOlsen Martin G · Anchorage, AKBuilt 1976 · S/N 18502917 N428AMT G Mendell Corp · New York, NYBuilt 2020 · S/N 4896 N428ANPatriot Flyers LLC · Lake Havasu City, AZBuilt 2006 · S/N 2092 N428APPaper Plane Aviation LLC · Sharpsburg, GABuilt 2026 · S/N 11406 N428BKBonato Sean · Glendive, MTBuilt 2010 · S/N ESP-205-8 N428BLFlying Money Pit LLC · Des Moines, IABuilt 1965 · S/N 18256552 N428CMN428cm LLC · Indianapolis, INBuilt 2007 · S/N 31-0042 N428DLGiair LLC · Morristown, TNBuilt 1976 · S/N 310R0657 N428ESPbjd Aviation LLC · Henderson, NVBuilt 2017 · S/N 1572

Back to AD 2000-23-21