Registered aircraft · 56,580

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-14-R1') 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-14-R1') 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-14-R1')
    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-14-R1')
  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-14-R1')
  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-14-R1')
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.

N3343VVitale Paul P · Green Valley, AZBuilt 1974 · S/N 15076468 N3344JSaitto Jeffrey M · Media, PAS/N 15066044 N3344RStorm Water Services Inc · Redmond, ORBuilt 1967 · S/N 18258644 N3344UPiescinski Kurt G · Fort Lauderdale, FLBuilt 1963 · S/N 18254744 N3345FBrassard Alan Gaston · Durham, NCBuilt 1966 · S/N 18257345 N3345RJennings Mamie M · Springfield, ILBuilt 1967 · S/N 18258645 N3345SSummit Foundry Systems Inc · Fort Wayne, INBuilt 1969 · S/N 21059145 N3345TJefts Donald R · Scotia, NYBuilt 1967 · S/N 17700645 N3346EEarnst Kelly S · West Lafayette, INBuilt 1978 · S/N 17271512 N3346LHarper Matthew Clay · Anchorage, AKS/N 185-1274 N3346RGonzalez Oscar · Bedford, TXBuilt 1968 · S/N 18258646 N3346YVantrease Jerold L · Homer, AKBuilt 1962 · S/N 18254346 N3347FPrescott Aircraft & Automotive LLC · Prescott Valley, AZBuilt 1966 · S/N 18257347 N3347LAcumen Aerotech LLC · Rogers, TXBuilt 1967 · S/N 185-1275 N3347SArmitage Justin Marc · Hugoton, KSBuilt 1969 · S/N 21059147 N3347YMccoy Mark B · Honea Path, SCBuilt 1962 · S/N 18254347 N3348UCollins Christopher E · Bluford, ILBuilt 1963 · S/N 18254748 N3348YBlue Sky Flyers Inc · Punta Gorda, FLBuilt 1962 · S/N 18254348 N3349DWeninger Gregory M · Burrton, KSBuilt 1955 · S/N 32147 N3349FMaxfield David · Greenville, SCBuilt 1966 · S/N 18257349 N3349SJin Jin Aviation LLC · Anchorage, AKBuilt 1984 · S/N 17276255 N334SASchaumburg Flying Club Nfp · Palatine, ILBuilt 1998 · S/N 18280393 N334SCGist Sally R · Horseshoe Bay, TXBuilt 1960 · S/N 50691 N334SPSierra Pop Air LLC · Wilmington, DEBuilt 2003 · S/N 172S9494 N334WCenturion Investments Inc DBA · Chesterfield, MOBuilt 1976 · S/N U20603331 N334WDSouthwest Aviation Enterprises · Haslet, TXBuilt 2011 · S/N 20608334 N334YWarner Aric D · Rosamond, CAS/N 18051299 N33503Sueltenfuss Tyler G · Boerne, TXBuilt 1967 · S/N R-172-0242 N3350FStrait Daniel · Sierra Vista, AZBuilt 1966 · S/N 18257350 N3350SBarry Jason J · Orange, CABuilt 1969 · S/N 21059150 N3350UKragseth Kyle A · Shoshone, IDBuilt 1963 · S/N 18254750 N33512Kennedy John D · Clinton Twp, MIBuilt 1966 · S/N R172-0099 N3351LGagnon Philip F · Anchorage, AKBuilt 1967 · S/N 185-1303 N3351STarantino Nicholas T Jr · Union City, CAS/N 21059151 N3351TTaylor Gail L · Red Bluff, CAS/N 17700651 N3352FDaradici Jodi A · Gilbert, AZBuilt 1966 · S/N 18257352 N3353TDwinell Jeffrey C · Granby, MABuilt 1967 · S/N 17700653 N3353UWieser Ranch Inc · Vernon, COBuilt 1963 · S/N 18254753 N3354YFelkins Roger C · Hillsboro, ALBuilt 1962 · S/N 18254354 N3355EMiddletown Regional Flight Training Institute LLC · Middletown, OHBuilt 1978 · S/N 17271515 N3355RSkyhawks Flying Club Inc · Canton, SDBuilt 1967 · S/N 18258655 N3356FShroyer Scott E · Peyton, COBuilt 1966 · S/N 18257356 N3356SBbt Inc · Wilmington, DEBuilt 1969 · S/N 21059156 N3356TCarlin Joseph A Jr · Rapid City, SDS/N 17700656 N3356VCavu Pilot LLC · Powell, TNBuilt 1974 · S/N 15076471 N3357DHodel Lawrence E · Hayden, IDBuilt 1955 · S/N 32155 N3357JHagghult Christer · Bonney Lake, WABuilt 1967 · S/N 15066057 N3357LMark II Aviation LLC · Corvallis, MTBuilt 1967 · S/N 185-1309 N3357THigh West Aero LLC · Broadus, MTBuilt 1967 · S/N 17700657 N3357URunway Ventures LLC · Salida, COBuilt 1963 · S/N 18254757

Back to AD 79-10-14 R1