Registered aircraft · 40,396

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.

N6477JSweat Jeremy A · Morrill, KSS/N 28-4904 N6477WWashington Samuel L · Cleveland, MSBuilt 1965 · S/N 28-20551 N64786Magee Wayland G · Bennington, NEBuilt 1961 · S/N 17557075 N6478DBrezovich Ivan A · Birmingham, ALBuilt 1979 · S/N 17272826 N6478JPart Guy LLC · Berlin, NJS/N 28-4905 N6478WLamar Edward Blake Jr · Rch Palos Vrd, CABuilt 1964 · S/N 28-20552 N64792Air Sal Leasing Inc · Fort Myers, FLS/N 17275625 N6479JBabula Ronald Lee Jr · Drums, PABuilt 1968 · S/N 28-4906 N6479RGromada Kristian Paul · Eagle River, AKBuilt 1966 · S/N 28-21669 N6479WManagement Ranch LLC · Sheridan, WYBuilt 1964 · S/N 28-20553 N647CABilli The Flying Cat LLC · Atlanta, GABuilt 1978 · S/N 28-7890312 N647FLRegistration Pending · Fruitland Park, FLRegistration pendingBuilt 1971 · S/N 28-7125555 N647JRAlexander Robert · Middleton, IDBuilt 1989 · S/N 1809020 N647MHanbo Aviation Inc · Wilmington, DEBuilt 2013 · S/N 60474 N647MTArbo Elijah B · Mount Chase, MEBuilt 1970 · S/N 17259158 N647RSSkorupa Ralph J · Salem, WIBuilt 1997 · S/N RS-01 N6480DFlyright Aviation LLC · North Las Vegas, NVBuilt 1979 · S/N 17272828 N6480JBeaver Douglas G · Harleysville, PABuilt 1968 · S/N 28-4908 N6481JCape Flight Instruction Inc · Cotuit, MABuilt 1980 · S/N 17273876 N6482JSmart Avionics Inc · Marietta, PABuilt 1968 · S/N 28-4910 N64834Golden Mahalo LLC · Sheridan, WYBuilt 1982 · S/N 17275632 N6483JCimarron Flying Lc · Elkhart, KSS/N 28-4912 N6483UFalk Edward A · Seattle, WAS/N 2230 N6484JMathis Flight Solutions LLC · Dubberly, LABuilt 1968 · S/N 28-4913 N6485JYankee Flyers LLC · Berryville, VABuilt 1968 · S/N 28-4914 N6485WShades Daniel L · Tumwater, WABuilt 1965 · S/N 28-20560 N64866Universal Aviators Academy Inc · El Monte, CABuilt 1982 · S/N 17275639 N6486JSpredemann Carl A · Emmett, IDBuilt 1980 · S/N 17273877 N6486UDof Aviation Inc · Schertz, TXBuilt 1962 · S/N 2233 N6486WSommerfeld Jordan Maxwell · Kittanning, PABuilt 1964 · S/N 28-20561 N6487DWayne County Airport Board · Monticello, KYBuilt 1979 · S/N 17272831 N6487RNurney Steven P · Fountain Hills, AZBuilt 1966 · S/N 28-21678 N6487UScheifele Gay F · Derwood, MDBuilt 1962 · S/N 2234 N6488JWccrt LLC · Enterprise, KSS/N 28-4918 N6488R6 Aerospace LLC · Albuquerque, NMS/N 28-21679 N6488UWings Leman F · Richmond, CAS/N 2235 N6488WKendall Ralph L Jr · Cape Coral, FLBuilt 1965 · S/N 28-20563 N64892Montgomery Flying Club Inc · Montgomery, ALBuilt 1982 · S/N 17275644 N6489JPatten Jeffery D · Rapid City, SDBuilt 1968 · S/N 28-4920 N648SAFour Delta Tango LLC · Wilmington, DEBuilt 2005 · S/N S-0010 N648VKuitems Philip P · Mt Juliet, TNBuilt 1960 · S/N TD-340 N648WBHunt Billy Dean · Rowland, NCS/N 22021C N6490DCampbell James W · Joshua, TXBuilt 1979 · S/N 17272832 N6490RDunn Christopher E · Amana, IAS/N 28-21681 N64915Northwoods Air LLC · Orono, MEBuilt 1982 · S/N 17275649 N64919Hawk III Flyers Club · Republic, PABuilt 1973 · S/N 17262850 N6491JEleven X Club Inc · Jeffersonville, INBuilt 1968 · S/N 28-4922 N6491RGonzales Christian J · Dallas, TXBuilt 1966 · S/N 28-21683 N6491UAllen Todd C · Abingdon, VABuilt 1962 · S/N 2238 N6491WHuddleston Ronnie L · North Vernon, INBuilt 1965 · S/N 28-20567

Back to AD 79-10-03 R2