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.

N7770WN7770w LLC · Sheridan, WYBuilt 1964 · S/N 28-1771 N7771GEmpire Aero Club Inc · Sebastopol, CABuilt 1970 · S/N 17259471 N7771NSale Reported · Copper Center, AKSale reported, pending cancellationS/N 28-5218 N7771RWeatherbee Mark B · Lincoln, MEBuilt 1995 · S/N 687 N7771WWhitman Edward G · River Falls, WIBuilt 1964 · S/N 28-1773 N7772CCummings David P · Grayson, LABuilt 1975 · S/N 28-7625084 N7772DWilliams Stephen M · Fort Walton Beach, FLBuilt 1957 · S/N 18-5958 N7772GWings Over Texas Holdings LLC · Denton, TXBuilt 1970 · S/N 17259472 N7772NZmq Aviation LLC · Minneapolis, MNBuilt 1968 · S/N 28-5219 N7773NDmac Aircraft LLC · Savannah, GABuilt 1968 · S/N 28-5221 N7773WVida Kenneth J · Harrison Township, MIBuilt 1964 · S/N 28-1776 N7774DPosson John L Trustee · Petaluma, CABuilt 1957 · S/N 18-5957 N7774GElliott Miles · Porterville, CABuilt 1970 · S/N 17259474 N7774NRai Jeff · Nazareth, PABuilt 1968 · S/N 28-5222 N7774TPanjab Aviation · Las Vegas, NVBuilt 1979 · S/N ME-191 N7775GMondragon Vidahk D · Reseda, CAFirst renewal noticeBuilt 1970 · S/N 17259475 N7775NHarris Mark · Greenville, SCBuilt 1968 · S/N 28-5223 N7775SWildes Thomas · Chippewa Falls, WIBuilt 1976 · S/N 227-76 N7776DSecond Delaware Corp · Moorestown, NJBuilt 1957 · S/N 18-5961 N7776GGulf Atlantic Airways Inc · Gainesville, FLBuilt 1970 · S/N 17259476 N7776NSkylark Flight Training LLC · Wilmington, DEBuilt 1968 · S/N 28-5224 N7776PHardin Gerald A · Port Clinton, OHFirst renewal noticeBuilt 1962 · S/N 24-2993 N7776ZThatcher William Scott · Eau Claire, WIBuilt 1966 · S/N 18-8483 N7777CSouthern Sky LLC · Henderson, NVBuilt 1976 · S/N 17267334 N7777DMorris Blain E · Delta Junction, AKBuilt 1954 · S/N 18-5962 N7777PWeihe Philip D · Cleveland Heights, OHBuilt 1961 · S/N 24-2994 N7777WAmmon Roadable Aircraft LLC · Manchester, NHBuilt 1964 · S/N 28-1781 N7778BPeters Ben C · Leavenworth, WAS/N 2750 N7778NAsari Investments LLC · Knoxville, TNBuilt 1968 · S/N 28-5225 N7779CDicey Aviation LLC · Somerset, KYBuilt 1975 · S/N 28-7615063 N7779DEssman Kenneth R · Burlington, WIS/N 18-5964 N7779NPhyxsius Aviation LLC · El Paso, TXBuilt 1968 · S/N 28-5226 N7779WHolowatsch Sergio O · Archer, FLBuilt 1964 · S/N 28-1785 N777AHJarhead Aviation LLC · Port Saint Lucie, FLBuilt 1973 · S/N 17261695 N777CCJohnston Steven M · Lyle, WABuilt 1984 · S/N S-300-CC-1 N777CYMiller Shawn C · Milaca, MNBuilt 1996 · S/N 24482 N777DUSc Infinities LLC · Dover, DEBuilt 1971 · S/N 17259854 N777DVTharp Thomas J · Nampa, IDBuilt 1998 · S/N 105M N777EZInternational Aviation Group LLC · Lake Wales, FLBuilt 1978 · S/N 28-7916216 N777GC777gc Holdings LLC · Milford, CTBuilt 1975 · S/N AA5B-0167 N777GEAir Float One LLC · Stuart, FLBuilt 1978 · S/N AA5B0741 N777LCSelover Stephan Holger A · Lake Oswego, ORBuilt 1974 · S/N 349 N777LH7 Moon LLC · Albuquerque, NMS/N 3151 N777PWAerowest LLC · Independence, ORBuilt 1976 · S/N AA5B-0389 N777SNichols Max E · Great Bend, KSBuilt 1981 · S/N 18-8109040 N777SDBoomerang Air LLC · Cedar Park, TXBuilt 1980 · S/N 28-8190125 N777SRWilkie David J · Nashua, NHS/N 28-20268 N777SXSkinner Norman D · Osceola, IABuilt 1993 · S/N 3025 N777TRBlack Vernon N · Hildale, UTS/N 1859 N777UHRobinson Helicopter Company Inc · Torrance, CABuilt 2004 · S/N 3548

Back to AD 79-10-03 R2