Registered aircraft · 56,580

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-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.

N42951Tiedt Randy · Parkville, MOBuilt 1968 · S/N 18259264 N42955Brown Donald E Jr · Jonesboro, ARS/N 18259265 N42958Havasa Enterprises LLC · Sisters, ORBuilt 1973 · S/N 18052389 N4295LBravo Aviation LLC · Rexburg, IDBuilt 1966 · S/N 17254364 N42967Brook Daniel L · Marshall, INBuilt 1968 · S/N 18259269 N42968Jelinek Spencer T · Erie, COBuilt 1973 · S/N 18052390 N4296FMargraf Todd R · Miamisburg, OHBuilt 1958 · S/N 46196 N4296LBreidenbach Todd J · Sabin, MNBuilt 1966 · S/N 17254365 N4296QAirjohn LLC · Cheyenne, WYBuilt 1971 · S/N 17260196 N42972Anderson Mike D · Mc Alpin, FLBuilt 1968 · S/N 18259271 N42974Tracy Lanning Construction LLC · Westminster, SCBuilt 1968 · S/N 18259272 N4297547q LLC · Eau Claire, WIBuilt 1968 · S/N 18259273 N4297QCritchfield David P · Paradise, CAS/N 17260197 N4297UMondrik Michael R · Blessing, TXS/N 15060297 N42980Friday Dale C · Santa Cruz, CABuilt 1968 · S/N 18259274 N4298FGunn Sean · Colorado Springs, COBuilt 1958 · S/N 46198 N4298QDarrach Todd I · Rhome, TXS/N 17260198 N4299FRomano Louis A · Middletown, NJBuilt 1958 · S/N 46199 N4299UJohnson Daniel P · Williamsburg, IAS/N 15060299 N429BASchmidt John M · Palm Coast, FLS/N 17702654 N429CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 2001 · S/N 172S8691 N429DLLandset David J · West Palm Beach, FLBuilt 1975 · S/N 21060649 N429EPBbm Air LLC · Macon, GAFirst renewal noticeBuilt 2001 · S/N 17280608 N429ESBarbers Point Flight School LLC · Kapolei, HIBuilt 1997 · S/N 17280296 N429FFDhs Operations LLC · Wilmington, DEBuilt 2004 · S/N 17281229 N429JPHnb Aviation LLC · Forestburg, TXBuilt 2007 · S/N 18281955 N429LChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11452 N429PCShanks Charles Scott · Edmonds, WAS/N 18051629 N42APMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1977 · S/N 17269941 N42AVIsland Aero LLC · East Northport, NYBuilt 1982 · S/N 18268267 N42BHDondelinger Consulting LLC · Brainerd, MNS/N 18268199 N42CMMazor Chris · Belleville, MIS/N 17266374 N42EMNbc Sales LLC · Somerville, TNBuilt 1967 · S/N 18258542 N42EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 1965 · S/N 15061252 N42JAJersey Aero Club Inc · Lakewood, NJBuilt 1976 · S/N 17267383 N42KCChatham Kenneth W · Montross, VABuilt 1968 · S/N 18259044 N42LLGayden Marshall G · Wilmington, NCBuilt 1999 · S/N 172S8269 N42RHGet-U-There Air LLC · Poplar Grove, ILBuilt 1979 · S/N 18266776 N42RLChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280405 N42VVSilverhawk Aviation Academy Oregon LLC · Ontario, ORS/N 172RG0703 N42WDRegistration Pending · Seattle, WARegistration pendingBuilt 1972 · S/N 18261403 N42WGEl Paso Industries Inc · Santa Teresa, NMBuilt 1969 · S/N 18259414 N4300QFarwell Christopher J Trustee · Olympia, WABuilt 1973 · S/N 18502232 N4300RCab Air Inc · Columbia, NJBuilt 1974 · S/N 17263054 N4301BCff LLC · Kalispell, MTBuilt 1955 · S/N 26645 N4301QSchneider Frederick I · Sault Sainte Marie, MIBuilt 1971 · S/N 17260201 N4301RMeggers Roger D · Baker, MTBuilt 1974 · S/N 17263055 N4302LSenn Steve E · Burwell, NEBuilt 1966 · S/N 17254371 N4302ULarson Gary L · Elgin, TXBuilt 1964 · S/N 15060302 N4303BWetherbee Michael · Howell, MIBuilt 1955 · S/N 26647

Back to AD 79-10-14 R1