Skip to content

Registered aircraft · 4,000

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-13-10-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-13-10-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-13-10-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-13-10-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-13-10-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-13-10-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.

N1109MPatrick Chris J · Paris, ILBuilt 1970 · S/N 33701309 N110BWAtwater David C · Pompano Beach, FLS/N 1538 N110CAFargo Jet Center LLC · Fargo, NDBuilt 1975 · S/N 34-7570219 N110MJTuggle Jason C · Liberty Hill, TXBuilt 1975 · S/N 34-7570117 N110NPJungemann Jeff D · Brigham City, UTBuilt 1973 · S/N 33701565 N110PAPostupack Peter Jr · New Cumberland, PAS/N 25-2007 N110RLProctor Charles L · Alachua, FLBuilt 1973 · S/N P3370095 N110RVMillspaugh John · Weatherford, OKBuilt 1981 · S/N 34-8133196 N110SMPenhall Michael Joseph · Lake Forest, CABuilt 1964 · S/N 337-0023 N111ATSkymaster Stc LLC · Mena, ARBuilt 1969 · S/N 337-1125 N111HVBga-Viation · Bennettsville, SCBuilt 1979 · S/N R1723289 N111PHGood Flight Aviation LLC · Stockton, CABuilt 1978 · S/N 34-7970001 N111RTJcec LLC · Washington Tr, UTBuilt 2001 · S/N 1156 N111RXThompson William · Tampa, FLS/N 347770134 N111SMMuller Aviation LLC · New Baltimore, MIBuilt 1977 · S/N 34-7770333 N112CAWickter Lawrence D Jr · Sugar Grove, ILBuilt 1972 · S/N 23 N112RCStraubel Investments Inc · Egg Harbor, WIBuilt 1973 · S/N 79 N1131QFarm Country Air LLC · Jefferson, IABuilt 1977 · S/N 28R-7703053 N1139ZGonet John Charles · Southwick, MABuilt 1981 · S/N 25-0617 N113DFRegistered aircraftBuilt 1998 · S/N 3449062 N113VKHaskell Brenton · Georgetown, KYBuilt 1978 · S/N 28R-7803352 N1140TRegistered aircraftBuilt 1981 · S/N 25-0618 N1141BMiddleton Robert J · Truth Or Consequen, NMBuilt 1981 · S/N 25-0574 N1141HMorris David · Hillsdale, MIBuilt 1967 · S/N 337M0013 N1142XAerofeather Aviation Inc · Suffolk, VAS/N 34-7570221 N1143WRiner Mark G · Bartlesville, OKBuilt 1981 · S/N 25-0587 N1146MMitchell Kenneth A · Uniontown, PABuilt 1972 · S/N 33701446 N1147DWesterhold Wayne E · Cary, NCBuilt 1981 · S/N 25-0594 N1147GIcarus Transport LLC · Charlotte, NCBuilt 1981 · S/N 25-0595 N1147VRegistration Pending · Moore, OKRegistration pendingBuilt 1976 · S/N R1722122 N1149BStefenelli Aviation N Tr Inc Trustee · AtterseeBuilt 1981 · S/N 25-0603 N1149GShine Flyer LLC · Kalispell, MTBuilt 1981 · S/N 25-0606 N1149HN1149h Inc · Pembroke Pines, FLBuilt 1981 · S/N 25-0607 N1149LAviation Trust Company LLC Trustee · Oklahoma City, OKS/N 25-0608 N1149PWilliams Joseph A · Jacksonville, FLBuilt 1981 · S/N 25-0609 N114BSBravo Sierra LLC · Seattle, WABuilt 2002 · S/N 1192 N114JRN114jr LLC · Canyon Lake, CABuilt 1975 · S/N 34-7570152 N1150UHaskins Kerry H · Tampa, FLBuilt 1981 · S/N 25-0623 N1151UCoconut Telegraph LLC · Missoula, MTBuilt 1981 · S/N 24-1230 N1152KVan Hook James W · Sylvania, OHBuilt 1981 · S/N 25-0626 N1152LMcdonald Glenn · Uvalde, TXS/N 25-0627 N1152NDowd Tedd J · Goodyear, AZBuilt 1981 · S/N 25-0628 N1152QHilterbrand Wayne D Jr · Keizer, ORBuilt 1981 · S/N 25-0629 N1152VGolden Eagle Consulting LLC · Williston, NDS/N R1722123 N1156Ind Aerospace LLC · Lumber Bridge, NCS/N 337M0381 N1156GWilliams Michael E · Horseshoe Bay, TXBuilt 1981 · S/N 25-0639 N1156KN1156k 231 LLC · Dearborn Heights, MIBuilt 1982 · S/N 25-0651 N1156MJays Aircraft Maintenance Inc · Costa Mesa, CAS/N 25-0642 N1157GPennington P · The Colony, TXBuilt 1982 · S/N 25-0729 N1157JAvinate LLC · Orlando, FLS/N 25-0643

Back to AD 81-13-10 R1