Skip to content

Registered aircraft · 40,395

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

N2080VMcguire Rental Properties LLC · Prescott, ARBuilt 1979 · S/N 28-7916322 N20811Rtd Aviation LLC · Hillsborough, NJBuilt 1974 · S/N 17263843 N2081CTrident Aircraft Inc · Easton, MDBuilt 1978 · S/N 28-7916128 N20823American Patrols Inc · Midland, TXBuilt 1974 · S/N 17263848 N20825Sussman Stanley M · New Castle, DEBuilt 1974 · S/N 17263849 N20834Climb Maintain LLC · Morrisville, MOBuilt 1974 · S/N 17263850 N20837Mjm Enterprise Holdings LLC · Drexel, MOBuilt 1974 · S/N 17263851 N2083DSale Reported · Crystal, MNSale reportedBuilt 1978 · S/N 44-7995126 N20843St Louis Flying Club Inc · Ellisville, MOBuilt 1974 · S/N 17263853 N2084ASunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 44-7995081 N2084EBuchholz Steve DBA · Clarkston, MIBuilt 1978 · S/N 17271148 N2084PSchalk Bretta J · Fountain Run, KYBuilt 1956 · S/N 23-672 N20858Vintage Flyers Inc · Napa, CABuilt 1974 · S/N 17263857 N2085VForbes Aviation LLC · Boise, IDBuilt 1979 · S/N 28-7990337 N20864Dishart Bradley E · Gibsonia, PABuilt 1978 · S/N 28-7990026 N20865Agasair LLC · East Hampton, NYBuilt 1974 · S/N 17263859 N2086PSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1956 · S/N 23-674 N2086RRobison Robert S · Collinsville, ILBuilt 1969 · S/N 28-5458 N20871High Flight Academy LLC · Allison Park, PABuilt 1975 · S/N 17263862 N20873Mang Aero Club · Belleville, MIBuilt 1978 · S/N 28-7990027 N20876Ogalalla Land & Cattle Ltd · Douglas, WYS/N 17263863 N2087EPcs Aviation LLC · La Canada, CABuilt 1978 · S/N 17271150 N2087NRls Rental Co DBA · Joplin, MOBuilt 1979 · S/N 28-7916253 N2088AGary Jet Center · Gary, INBuilt 1978 · S/N 28-7916092 N2088BGeneral Aviation Support Corp · Rosamond, CABuilt 1978 · S/N 28-7916108 N2088VMad Scientist Aviation LLC · Wilmington, DEBuilt 2002 · S/N 465-2002 N20891Morristown Flying Service Inc · Talbott, TNBuilt 1974 · S/N 17263867 N2089ESkyhawk N2089e Ltd · Deerfield, ILBuilt 1978 · S/N 17271151 N2089KBrown Frank J · Cold Spring, NYBuilt 1978 · S/N 44-7995176 N2089NSchroeder Reinhard · Poulsbo, WABuilt 1979 · S/N 28-7916255 N2089RSchwettmann Dennis E · Nampa, IDBuilt 1993 · S/N 17 N208ATLeciejewski Darrell K · Mc Alpin, FLBuilt 1976 · S/N 17268379 N208CAChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 4496161 N208EFAero208 LLC · Boise, IDBuilt 1966 · S/N 28-3632 N208GGPenn Yan Flying Club Inc · Penn Yan, NYBuilt 1975 · S/N 28-7690073 N208PFChristensen Todd S · Ririe, IDBuilt 2014 · S/N 6793 N208PLLutz Paul Trustee · Seville, OHBuilt 2006 · S/N 24239 N208RDChase Donaven Ray · Lake Elmo, MNBuilt 2003 · S/N 90178 N2090PMartin Vernon W · Peoria Heights, ILS/N 23-678 N2090RRubright Erik M · Gladstone, MIBuilt 1969 · S/N 28-4975 N2090VWater Sports Unlimited · Griffin, GABuilt 1979 · S/N 28-7990339 N20912Dart Gregory G · Mayville, NYBuilt 1976 · S/N 1 N2091BRegistered aircraftBuilt 1978 · S/N 28-7990117 N2091DRegistration Pending · Magnolia, TXRegistration pendingBuilt 1978 · S/N 28-7916141 N20921Brigham David F · Elliottsville Twp, MEBuilt 1974 · S/N 17263869 N2092AKimmons Anthony J · Quitman, TXBuilt 1978 · S/N 28-7916094 N2092XAirx LLC · Warwick, RIBuilt 1979 · S/N 28-7916342 N20932Registration Pending · Hammond, LARegistration pendingBuilt 1974 · S/N 17263872 N20933Meacham Bruce E · Kansas City, KSS/N SA-233 N20934Fly Skyhawk Llp · Galena, OHBuilt 1974 · S/N 17263874

Back to AD 79-10-03 R2