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.

N159DSSmart Charles R · Verden, OKBuilt 1978 · S/N 70384 N159DWWilcoxon Duane E · Arlington, WAS/N PITTS 01 DW N159ERTetterton Marshall O · Crescent City, FLBuilt 1989 · S/N 2841211 N159NDSkyborne Airline Academy Inc · Vero Beach, FLBuilt 1998 · S/N 2842031 N159RJBas Part Sales LLC · Greeley, COBuilt 1973 · S/N 17702038 N159RVTullos George E · Madison, MSFirst renewal noticeBuilt 2003 · S/N 90362 N159TMKcsi Aerial Patrol Inc · Bakersfield, CABuilt 2002 · S/N 462-2002 N159WMFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 2002 · S/N 4496159 N15ADDurrent Aviation LLC · Anchorage, AKBuilt 1978 · S/N 18-7809065 N15AFRogers Jeff · Harrogate, TNBuilt 1976 · S/N 17267237 N15BCWingsleasing LLC · Wichita, KSBuilt 1964 · S/N 28-1712 N15CHOrlando Flight Academy Inc · Apopka, FLBuilt 1974 · S/N 28-7415277 N15CMCarolina Aero Group LLC · Youngsville, NCBuilt 2004 · S/N 2280 N15CZSafe Aero LLC · Fort Myers, FLBuilt 2005 · S/N 72 N15DEVlazny Stephen F · Divide, COBuilt 1992 · S/N 1 N15DVJoiner Robert W · Worton, MDS/N SDV-RJ-02 N15ESCyr Gregory A · Augusta, MEBuilt 1988 · S/N 001 N15FPFoxtrot Papa LLC · Slidell, LABuilt 1977 · S/N 17268574 N15GWFlight Brothers LLC · Sachse, TXBuilt 1969 · S/N 17258161 N15HJMorehouse Cooper · North Pole, AKS/N 17268950 N15JWTri-Cap International · Roanoke, TXBuilt 1959 · S/N TD-225 N15LFNorthrup George William · Ellicottville, NYBuilt 1998 · S/N 1395 N15LRBoggs James A · Tucson, AZBuilt 1994 · S/N 1309 N15LWIsaak Robert J · Pocatello, IDBuilt 2001 · S/N 90016 N15NBMorris Russell K · Cameron Park, CABuilt 1978 · S/N AA5B0974 N15NFRegistered aircraftBuilt 1969 · S/N 17258204 N15PCCarr Patrick L · Fairmont, WVBuilt 1997 · S/N 1214 N15QAQuiet Aero LLC · Fort Myers, FLBuilt 1960 · S/N 24-2388 N15RAAviation Career Enrichment Inc · Atlanta, GABuilt 1970 · S/N 17259568 N15RMFlying Y Farms LLC · Klamath Falls, ORBuilt 1969 · S/N 18-8814 N15RVCrawford Larry G · California, MOS/N 298 N15SEWilliams Paul E · Kendallville, INBuilt 2005 · S/N 1386-2005 N15SWNi Oliver Xingyuan · Norfolk, VABuilt 1968 · S/N 17256875 N15TSSchell Timothy N · Dubois, WYBuilt 1996 · S/N 23802 N15USale Reported · Van Nuys, CASale reportedBuilt 1979 · S/N ME-160 N1600RColeman Daniel L · Chattanooga, TNBuilt 1974 · S/N AA5-0700 N1601Moretti Warren R · Petaluma, CABuilt 2004 · S/N 20588 N16019Brown Kenneth D · Port Murray, NJS/N 17702478 N1601SRussell Bryan E · Joshua, TXS/N 28-7790057 N16021Hill Allen W · La Junta, COBuilt 1976 · S/N 17702479 N16023Carr Richard D Trustee · Stockton, MOBuilt 1976 · S/N 17702480 N1602BBoyd Aaron · S San Fran, CABuilt 1979 · S/N 17272737 N1602VRegistration Pending · Lucas, TXRegistration pendingBuilt 1974 · S/N 17263690 N1603EWright Michael A · Advance, NCBuilt 1978 · S/N 17271062 N16066Thompson Derek D Jr · Dunkirk, MDBuilt 1976 · S/N 17702482 N1606AFilkill David B · Willow, AKBuilt 1951 · S/N 18-1246 N1609EEilenfeld Teresa · Mansfield, OHBuilt 1978 · S/N 17271065 N160BAHitec Construction Services Inc · Lincoln, CABuilt 2002 · S/N 46M N160BCPridmore Reginald C · Laughlin, NVS/N 457-2004 N160CBBishop Christopher S · Houston, TXBuilt 1966 · S/N 15063780

Back to AD 79-10-03 R2