Registered aircraft · 40,394

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.

N9169THayes George F · Friendsville, PABuilt 1979 · S/N 18-8009012 N916ATKdrd Holdings LLC · Texas City, TXBuilt 1982 · S/N 17275931 N916AVLopez Virgilio D · Brookshire, TXS/N 17272800 N916BNAir Care Leasing LLC · Lamar, COBuilt 1998 · S/N 21085 N916CLDolphin Sales Inc · Wilkes Barre, PABuilt 1975 · S/N 17702273 N916HPNeustaeter Pedro Thiessen · Anthony, NMS/N 28-2658 N916JFHammett Gary N · Prince Frederick, MDBuilt 1974 · S/N 28-7405130 N916KSmith Brandon D · Laguna Beach, CABuilt 2005 · S/N 001 N916MHHelmerich Jonathan D Jr · Tulsa, OKBuilt 1969 · S/N 17258177 N916PYBragg Kris M · Embden, MEBuilt 1968 · S/N 17257159 N916RDUssery Donald R · Blytheville, ARS/N 23-1743 N916SEEiland James · Phenix City, ALBuilt 1977 · S/N 17269640 N916TTReyes-Hernandez Jose R · San Juan, PRBuilt 1989 · S/N 2841146 N916YEggimann William W Trustee · Anchorage, AKBuilt 1973 · S/N 18-7309023 N9170DSmith Glen R · Tracy, MNBuilt 1958 · S/N 22-6224 N9170SLee Benjamin W Trustee · Chandler, AZBuilt 1976 · S/N M-1783 N9170VMitchell Kevin L · Glen Saint Mary, FLBuilt 1969 · S/N 690032 N9171DJensen Timothy G · Junction City, ORBuilt 1958 · S/N 22-6226 N9171HSonday Terrance · Spring, TXBuilt 1975 · S/N 17265990 N9171JRichardson Adam D · Franklin, INBuilt 1966 · S/N 28-3232 N9172SShuffield Brian D · Oregon House, CAS/N M-1793 N9172YMohammadreza Sabzi · Los Angeles, CABuilt 1985 · S/N 28-8616034 N9173HSmitty 172 LLC · Rockford, MIBuilt 1975 · S/N 17265992 N9173XLinzel Jesse G Jr · Southern Pines, NCBuilt 1996 · S/N 11-176 N9174JOrleans Flying Club Inc · Orleans, INBuilt 1966 · S/N 28-3238 N9174MParis Air Inc · Vero Beach, FLBuilt 1985 · S/N 28-8616035 N9174TPiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 18-8009013 N9174VFrink Jeff · Chandler, AZBuilt 1969 · S/N 690033 N91751Aviators Cooperative LLC · Colorado Springs, COBuilt 1973 · S/N 17261509 N9175JSommer Eric M · London, OHBuilt 1966 · S/N 28-3241 N9176Elias Bernard J · Hampton, GABuilt 1970 · S/N 28P N9176DSmaha Daniel B · Glide, ORBuilt 1958 · S/N 22-6233 N9176HSky Walker Flight School LLC · Adrian, MIBuilt 1975 · S/N 17265993 N9176JPayson Aero Club LLC · Payson, AZBuilt 1966 · S/N 28-3242 N9177DCheyann Jordan · Coupeville, WABuilt 1958 · S/N 22-6234 N9177SNabeth Jeremy S · Austin, TXBuilt 1976 · S/N M-1789 N9178VWingman Aviation Partners LLC · Wentzville, MOBuilt 1969 · S/N 690017 N91793Oexmann James Bennett · Lexington, KYS/N 17261514 N9179HMeteiver Lawrence J · Elkhart, INBuilt 1975 · S/N 17265995 N9179SCharles Clarens · Brooklyn, NYBuilt 1976 · S/N M-1800 N9179VVinter Mooney LLC · Philadelphia, PAS/N 690035 N917DKEncore Jet Management LLC · San Antonio, TXBuilt 1998 · S/N 2843186 N917FAAlpha Aircraft International LLC · Lake Worth, FLBuilt 1980 · S/N 17274062 N917GKAmdel Holding LLC · Houston, TXBuilt 1978 · S/N 17271567 N917KDRegistered aircraftBuilt 1976 · S/N AA5A0156 N917PFBrown Charles James · Littlefield, TXBuilt 1995 · S/N 21339 N917TCDebarros David · Ashland, VABuilt 1998 · S/N 2843167 N917VKNorthern Lights Ventures LLC · Moose Pass, AKBuilt 1974 · S/N 18-7409056 N917WSRv Time LLC · Cape Coral, FLBuilt 2000 · S/N 21657 N917WTStamsta David T · Ennis, MTBuilt 2003 · S/N 00-1170

Back to AD 79-10-03 R2