OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,396

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
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.

N6409UJohnson Lynn · San Diego, CAS/N 2156N640KRCarson Michael W · Oxnard, CABuilt 2011 · S/N 71028N640MGAviate LLC · Green Bay, WIBuilt 1975 · S/N 17265248N640SAMcm Aircraft LLC · San Antonio, TXBuilt 2005 · S/N S-0003N640TCWingsleasing LLC · Wichita, KSS/N 2843491N64103Parra Raymond · Miami, FLS/N 17275522N64106Long Leslie Bruce Jr · New Durham, NHBuilt 1981 · S/N 17275523N64107Cmbb Enterprises LLC · Plainview, TXBuilt 1975 · S/N 17265023N64108Wiater Mark S · Crete, ILBuilt 1975 · S/N 17265024N6410JNoggle George · Bucyrus, OHBuilt 1968 · S/N 28-4827N6410USturm Daniel A · Carroll, IABuilt 1962 · S/N 2157N6410VEckerle Christopher K · San Bruno, CABuilt 1980 · S/N 172RG0672N6410WChandler Robby · New Hope, ALS/N 18-8178N64111Jasper Co Airport Authority · Rensselaer, INBuilt 1975 · S/N 17265027N64114Mccully Aviation LLC · Payson, AZBuilt 1975 · S/N 17265030N64119Augustus Aircraft LLC · Whitefish, MTBuilt 1975 · S/N 17265034N6411CWilcoxen Mark A · Bargersville, INBuilt 1978 · S/N 28-7816421N6411JPacific Union College · Angwin, CABuilt 1968 · S/N 28-4828N6411UPaselk Daniel Guy · Fort Myers, FLBuilt 1962 · S/N 2158N6411VSouth Air Aviation LLC · Miami, FLBuilt 1980 · S/N 172RG0673N6411WHis Promise Aviation Service · Big Spring, TXBuilt 1964 · S/N 28-20480N64120Ham Derek · Independence, ORS/N 17265035N64129Atlanta Aviation Academy Inc · Lawrenceville, GAS/N 17275525N6412DPort Aero Club Inc · Gold River, CABuilt 1979 · S/N 17272792N6412FRick Aviation Inc · Newport News, VABuilt 1979 · S/N 17273220N6412WFlying Otter Aviation LLC · Snellville, GABuilt 1964 · S/N 28-20481N64134Torres Felix · Dallas, TXBuilt 1975 · S/N 17265039N64135Flying Mermaid LLC · Aiea, HIBuilt 1975 · S/N 17265040N6413RLee Dylan Robert · Portland, ORS/N 28-21592N64140C64140 LLC · Bloomington, INBuilt 1975 · S/N 17265043N64147Summit Aviation Inc · Kingston, NYBuilt 1975 · S/N 17265047N6414JEight Three Quebec LLC · Orange, CABuilt 1968 · S/N 28-4831N6414RSommer Kelly L II · Galena, AKFirst renewal noticeBuilt 1966 · S/N 28-21593N6414UHensley James R · Bertram, TXBuilt 1962 · S/N 2161N6414WOttos Aviation LLC · Kenosha, WIBuilt 1964 · S/N 28-20483N64154Jw Skyhawk LLC · Austin, TXBuilt 1975 · S/N 17265049N64155Lowcountry Flight LLC · Johns Island, SCBuilt 1975 · S/N 17265050N64157Christensen Jeffrey S · Wisconsin Rapids, WIBuilt 1975 · S/N 17265052N64159Flying 14 LLC · Spokane, WABuilt 1975 · S/N 17265053N6415JFalcon Air Co · Marina Del Rey, CABuilt 1968 · S/N 28-4832N6415RAlpine Aviation Of Fayetteville Inc · Prairie Grove, ARBuilt 1979 · S/N 172RG0179N6415UMccall Richard A · Lexington, NCS/N 2162N6415VPeter Prince Aviation Center LLC · Milton, FLS/N 172RG0677N6415WMullins Tom H · W Alexandria, OHBuilt 1964 · S/N 28-20484N64160Glide Slope LLC · East Hampton, NYBuilt 1975 · S/N 17265054N64161Aom Aircraft LLC · Orlando, FLBuilt 1975 · S/N 17265055N64162Mccormick Philip D · Mount Pleasant, IABuilt 1975 · S/N 17265056N64163Good Airplanes LLC · Oshkosh, WIBuilt 1975 · S/N 17265057N64165Weaver Lynwood J Jr · Raleigh, NCBuilt 1975 · S/N 17265059N6416JGallant Kenneth R · Beach Haven, NJBuilt 1968 · S/N 28-4833
Back to AD 79-10-03 R2