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.

N7759DVezina Robert J · Rockford, MIBuilt 1957 · S/N 22-5442 N7759WGoedecke Chris A · Whitesboro, TXBuilt 1979 · S/N 28-7916411 N775GACougar Leasing LLC · Everett, WABuilt 1978 · S/N GA7-0062 N775GTToole Gregory Keith · Humble, TXBuilt 1977 · S/N 17268509 N775KTPrijatel Thomas J · Cordova, AKBuilt 1957 · S/N 18-5897 N775MCAmerican Patrols Inc · Midland, TXBuilt 1975 · S/N 17265008 N775PCMsb Aircraft LLC · Statesboro, GABuilt 1969 · S/N 28-5438 N775RHWuarin Jean Pierre · Pueblo, COBuilt 2001 · S/N #REH1 N775TAPrice Jeffrey R · Durand, ILBuilt 1976 · S/N 28-7715108 N775XHurst Thomas W · Broken Arrow, OKBuilt 1965 · S/N 28-2951 N7760GLeriche Nicolette · Oceanside, NYBuilt 1970 · S/N 17259460 N7761BTimblin Joel R · Boyceville, WIS/N 21846 N7761DState Of Alaska · Fairbanks, AKS/N 18-5940 N7761NRutter Matthew T · Arcadia, OHBuilt 1968 · S/N 28-5207 N7762NRegistered aircraftBuilt 1968 · S/N 28-5208 N7762WHenson Russell K · Santa Fe, NMBuilt 1964 · S/N 28-1761 N7763MZimmerman Kurt L · Blacksburg, VABuilt 1974 · S/N 20-0016 N7763NWever Marcus L · Lincolnton, NCBuilt 1969 · S/N 28-5209 N7763PRegistered aircraftBuilt 1961 · S/N 24-2980 N7763WSanchez Alyse Marie · San Antonio, TXBuilt 1964 · S/N 28-1762 N7764DHorn Bruce D Trustee · Zephyr Cove, NVS/N 18-5944 N7764GTriad Aviation Academy LLC · Greensboro, NCBuilt 1970 · S/N 17259464 N7764MEifert Steven W · Clarksville, TNBuilt 1974 · S/N 20-0017 N7765GJefferies Stanley J · Coos Bay, ORBuilt 1970 · S/N 17259465 N7765MProgressive Medical Applications Corp · Allentown, PABuilt 1974 · S/N 20-0018 N7765WTri-City Aviation Inc · Hopewell, VABuilt 1964 · S/N 28-1765 N7766GAir Ally Asset Management LLC · Chisago City, MNS/N 17259466 N7766NKenealy Ian Patrick · San Rafael, CABuilt 1969 · S/N 28-5212 N7766WBair Dale Leroy · Canton, OHBuilt 1964 · S/N 28-1766 N7767GPerformance Aviation LLC · Fort Myers, FLBuilt 1970 · S/N 17259467 N7767WFinan Kevin P · Seattle, WAS/N 28-1767 N7768NLeap Frog Aviation LLC · Bentonville, ARBuilt 1968 · S/N 28-5215 N7768WKilo Niner Aviation LLC · Saint Petersburg, FLBuilt 1964 · S/N 28-1769 N7769Sherburne Asher J · Redlands, CABuilt 1997 · S/N SN001LR N7769NWoolsey Bradley W · Burleson, TXBuilt 1968 · S/N 28-5216 N7769WSeverson Michael A · Nampa, IDBuilt 1964 · S/N 28-1770 N776ACMonska Stephen M · Florence, MABuilt 1997 · S/N 1233-97 N776AWKustatan Leasing LLC · Nikiski, AKBuilt 1964 · S/N 18-8139 N776BCTyndall Darryl K DBA · Deep Run, NCBuilt 2000 · S/N 2079 N776GAHinds Community College · Raymond, MSBuilt 1978 · S/N GA7-0065 N776MCCrew Sourcing Inc · Wilmington, DEBuilt 1957 · S/N 23-1078 N776RMiano Steven Mitchell · Clearwater, FLBuilt 2002 · S/N 22232 N776RVThams Kurt T · Soquel, CABuilt 1998 · S/N 002 N776SHExplore Helicopters LLC · Lexington, ALBuilt 2004 · S/N 3552 N7770BDunning John L · East Hampton, NYBuilt 1974 · S/N 28-7515108 N7770CMcgee Ronald S · Waco, KYBuilt 1975 · S/N 28-7625083 N7770DJenkins Robert H · Kill Devil Hills, NCBuilt 1972 · S/N 28R-7235220 N7770GMyers Keith R Trustee · Fond Du Lac, WIBuilt 1970 · S/N 17259470 N7770NThompson Brad J · Pleasant View, TNBuilt 1969 · S/N 28-5217 N7770PGlau Jon E · Englewood, COBuilt 1961 · S/N 24-2986

Back to AD 79-10-03 R2