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.

N9567DFurois Alex D · Bridger, MTBuilt 1958 · S/N 22-6484 N9567HCurley Mark L · Alamosa, COBuilt 1975 · S/N 17266234 N9567VBdc Aero LLC · Miami, TXRegistration expired, pending cancellationBuilt 1974 · S/N 17264369 N9567WMiler Aaron L · Chambersburg, PABuilt 1967 · S/N 28-23005 N9568CMitchell Stephen D · Wichita, KSBuilt 1978 · S/N 28-7890423 N9568GTakai Hiroyasu · San Jose, CABuilt 1979 · S/N 17273631 N9568LD & S Aviation LLC · Spring, TXBuilt 1986 · S/N 17276580 N9568URegistration Pending · Bath, PARegistration pendingBuilt 1975 · S/N AA5A-0068 N9568VAnderson Zachery D · Bigfork, MTBuilt 1974 · S/N 17264370 N9568WSale Reported · Cimarron, KSSale reportedBuilt 1967 · S/N 28-23006 N95690Daly Arthur P · El Paso, TXBuilt 2004 · S/N 101 N9569HOsborn Larry R · Summerville, SCBuilt 1975 · S/N 17266235 N956DCLefthalfplane LLC · Kalispell, MTBuilt 2004 · S/N 752E N956MAAllen William D · Tampa, FLBuilt 1966 · S/N 3431 N956MDDigit Aviation LLC · Hampton, NHBuilt 1956 · S/N 18-4884 N956TERaw Logistics LLC · Bethel, NCBuilt 2004 · S/N 10235 N9570JCharlie November Romeo LLC · Denver City, TXBuilt 1966 · S/N 28-3707 N9570UFranken Todd V · Martindale, TXBuilt 1975 · S/N AA5A-0070 N9571HWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17266236 N9571JMeunier Barry · Rehoboth, MABuilt 1966 · S/N 28-3708 N9571KOtter Fly LLC · Maricopa, AZS/N 28-7615213 N9571VTempleton John E · Loami, ILBuilt 1974 · S/N 17264373 N9572HGeneral Aviation LLC · Henderson, NVBuilt 1975 · S/N 17266237 N9572LJav Air Services LLC · Anchorage, AKBuilt 1986 · S/N 17276582 N9572VHill Timothy E · Hooks, TXBuilt 1974 · S/N 17264374 N9573BDocarmo Aviation LLC · Dallas, TXBuilt 1981 · S/N 172RG0890 N9573LCrosetto Pierre F · Downey, CABuilt 1974 · S/N AA5-0573 N9573SOppegard Nicholas D · Eagle River, AKBuilt 1966 · S/N 66 N9573VReynolds Darryl G · Wills Point, TXBuilt 1974 · S/N 17264375 N9573WPyxl Sky LLC · Cogan Station, PABuilt 1967 · S/N 28-23013 N9574BHinds Community College · Bolton, MSBuilt 1981 · S/N 172RG0891 N9574HJb III LLC · Stuart, FLBuilt 1975 · S/N 17266238 N9574LRiederich John B · Huntington Beach, CABuilt 1974 · S/N AA5-0574 N9574SKrejchik Daniel J · Portage, WIBuilt 1965 · S/N 14 N9575JJones Anthony J · North Royalton, OHBuilt 1966 · S/N 28-3712 N9575UBarnett Gary L · Bertram, TXBuilt 1975 · S/N AA5A-0075 N9575VFurnari Alfio · Hutchinson Island, FLBuilt 1974 · S/N 17264377 N9575WMike Flying Service LLC · Terrell, TXBuilt 1967 · S/N 28-23015 N9576CMercer Paul A · Salida, CABuilt 1978 · S/N 28-7816497 N9576JWright Jason C · Thorntown, INBuilt 1966 · S/N 28-3713 N9576KClearwater Valley Aero Club Inc · Kamiah, IDBuilt 1976 · S/N 28-7615215 N9577BRegistration Pending · Scottsdale, AZRegistration pendingBuilt 1981 · S/N 172RG0894 N9577DBerry Matthew G · Creedmoor, NCBuilt 1958 · S/N 18-6760 N9577JBrown Dennis N · Bakersfield, CAS/N 28-3715 N9577LSquire Barry H · Sarasota, FLBuilt 1974 · S/N AA5-0577 N9577USoluserv LLC · Caldwell, TXBuilt 1975 · S/N AA5A-0077 N9577VMdr Flying Inc Trustee · Wilmington, DEBuilt 1974 · S/N 17264379 N9578BHalseth Harald E · El Paso, TXBuilt 1981 · S/N 172RG0895 N9578JDesbien Paul D · Texhoma, OKBuilt 1966 · S/N 28-3716 N9578LRegistration Pending · Hoover, ALRegistration pendingBuilt 1974 · S/N AA5-0578

Back to AD 79-10-03 R2