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.

N3856JClifton Chad R · Asheboro, NCBuilt 1966 · S/N 15065156 N3856LSimmons Brandon M · Sylacauga, ALS/N 17254025 N3856RSmith Joseph M · Juneau, AKBuilt 1966 · S/N 17255356 N3856SSobie David M · Nome, AKS/N 17251056 N3857RLorring Eric Henry · Kodiak, AKBuilt 1966 · S/N 17255357 N3857VSrv Air Service LLC · Stockton, NJBuilt 1949 · S/N 18744 N3857YLutz Matthew B · Jackson, TNBuilt 1964 · S/N 21058357 N3858QPylant Eric Jon · Arnold, CABuilt 1971 · S/N 17259958 N3858RBaugh David · Kirkland, WABuilt 1983 · S/N U20606496 N3858SDearman Daniel R Sr · Cottonwood, CABuilt 1963 · S/N 17251058 N3858VMission Aviation LLC · Orange Park, FLBuilt 1975 · S/N 15076637 N3859CSweet Phillips R · Laguna Beach, CABuilt 1954 · S/N 31007 N3859JOnefiftyjuliet LLC · Saint Petersburg, FLBuilt 1966 · S/N 15065159 N3859LBourke Michael T · Adams, WIBuilt 1965 · S/N 17254028 N3859RLeja Dennis A · Watertown, WIBuilt 1966 · S/N 17255359 N3859SFlorance Robert L · Fort Worth, TXBuilt 1963 · S/N 17251059 N3859VK3 Safe Air LLC · Mokena, ILBuilt 1975 · S/N 15076638 N3859YMorse Donald W · Priest Lake, IDFirst renewal noticeS/N 21058359 N385CHL H Aviation LLC · Clanton, ALBuilt 1966 · S/N 17255354 N385DCDyncorp International Inc · Mcclellan, CABuilt 2021 · S/N 172S12651 N385KLIasco Flight Training Inc · Redding, CABuilt 1999 · S/N 172S8116 N385MAPesek Larry Paul · Steinhatchee, FLBuilt 1998 · S/N 18280419 N385RBNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282199 N385TDHomestead Helicopters Inc · Missoula, MTBuilt 1965 · S/N T210-0072 N3860LLake Area Technical College · Watertown, SDBuilt 1965 · S/N 17254029 N3860URana Jet LLC · Aubrey, TXS/N 336-0160 N3861CBuben Michael · Chandler, AZBuilt 1954 · S/N 31009 N3861LSeverson Marshall G · Anchorage, AKBuilt 1966 · S/N 17254030 N3861QLopez Mario J · Torrance, CABuilt 1971 · S/N 17259961 N3861RShawn James Robert · Pattison, TXS/N 17255361 N3861VVan Zant Mark · Zionsville, INBuilt 1949 · S/N 18748 N3861YMiller Todd D · Fort Wayne, INBuilt 1964 · S/N 21058361 N3862DReady Aim Flyer LLC · New Castle, DES/N 34562 N3862GRenfro Michael W · Bethel, AKS/N U206-0862 N3862JDoyle Ethan Mackenzie · Nunda, NYBuilt 1966 · S/N 15065162 N3862LSainsbury James L · Milton, WIBuilt 1965 · S/N 17254031 N3862QQ Flyers LLC · Anaheim, CABuilt 1971 · S/N 17259962 N3863DDulley Tony A · Nine Mile Falls, WABuilt 1957 · S/N 34563 N3863QCondor Air LLC · Pleasant Valley, NYBuilt 1971 · S/N 17259963 N3863ROkeefe Dennis G · Cincinnati, OHBuilt 1966 · S/N 17255363 N3863SRegistration Pending · Walker, MNRegistration pending, pending cancellationBuilt 1963 · S/N 17251063 N3864LDelvalle Dean · Schertz, TXBuilt 1965 · S/N 17254033 N3864QEvans James · Tuolumne, CAS/N 17259964 N3864RR Thimesch Construction LLC · Spivey, KSS/N 17255364 N3865JAlbert Bruce F · Dallas, TXBuilt 1966 · S/N 15065165 N3865LRibeiro Marcos Felix · Okeechobee, FLS/N 17254034 N3865QAmerican Patrols Inc · Midland, TXBuilt 1971 · S/N 17259965 N3865SIndy Air Sales LLC · Anderson, INBuilt 1963 · S/N 17251065 N3866CProfessional Pilots Inc · Lowell, INBuilt 1954 · S/N 31014 N3866LLamb Daniel A · Cheyenne, WYBuilt 1966 · S/N 17254035

Back to AD 79-10-14 R1