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

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.

N6901ULime Lounge LLC · Des Moines, IABuilt 1964 · S/N 2696 N6902DFerrell Alan B · Arlington, OHBuilt 1957 · S/N 22-4829 N6902NSherrill Charles H · Robert Lee, TXBuilt 1968 · S/N 680169 N6903BJones Gary L · Kerrville, TXBuilt 1956 · S/N 22-4175 N6903JGreen Valley Aerospace LLC · Lexington, VABuilt 1976 · S/N 28-7690425 N6903NRoland Jason R · Royse City, TXBuilt 1968 · S/N 680170 N6903QSullivan Lynford M · Hernando, MSBuilt 1967 · S/N MB-267 N6903UPray Aviation Inc · Augusta, KSBuilt 1964 · S/N 2698 N6904DLucas Michael F · Germantown, OHS/N 22-4831 N6904NSchaffhauser Daniel L · Garland, TXBuilt 1968 · S/N 680135 N6904UMyers Ronnie L DBA · Appling, GABuilt 1964 · S/N 2699 N6905DEvans Theresa K · Alexandria, MNBuilt 1957 · S/N 22-4832 N6905HTang Flyer LLC · Wausau, WIBuilt 1975 · S/N 17265638 N6905NZero Five November Holding Inc · Kalispell, MTBuilt 1968 · S/N 680171 N6905PMampel Gregory J · New Port Richey, FLBuilt 1960 · S/N 24-2039 N6905VOscar Mike Appraisal Group LLC · Greenville, SCBuilt 1975 · S/N 20-1175 N6905WPodeweltz Wayne L · Merrill, WIBuilt 1965 · S/N 28-21071 N6906QFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1967 · S/N MB-283 N6906VMatthews Cheryl L · Baker City, ORS/N 20-1176 N6907BJordan Walter B · Chehalis, WABuilt 1956 · S/N 22-4182 N6907NHensley Tyler · Leland, NCBuilt 1968 · S/N 680136 N6907VPounds Gregory S · Sykesville, MDBuilt 1975 · S/N 20-1177 N6908BMeriden Aviation Center LLC · Meriden, CTBuilt 1985 · S/N 28-8516050 N6908KRegistration Pending · Dillingham, AKRegistration pendingBuilt 1950 · S/N 20-12 N6908UPaul Michael · Fort Worth, TXBuilt 1964 · S/N 2703 N6908VForoozesh Paymon Michael · Olalla, WABuilt 1975 · S/N 20-1178 N6909BKaufmann Arnold L · Davenport, IABuilt 1956 · S/N 22-4184 N6909NDevore John A C · Marion, OHS/N 680174 N6909QHuston Lee E · Graham, WABuilt 1967 · S/N MB-281 N6909UVandivort Austin J · Strawberry Plains, TNS/N 2704 N690ABKirkland Klayton E · College Station, TXS/N B-001 N690BLincwings Society LLC · Austin, TXBuilt 1955 · S/N 23-382 N690JTAviationmt LLC · Kalispell, MTS/N 28-7205042 N690SHCorriher Mark B · Mocksville, NCBuilt 1966 · S/N 132 N6910DWood Robert A · Sheboygan, WIBuilt 1957 · S/N 22-4837 N6910JPlane Nonsense Inc · Middletown, DEBuilt 1976 · S/N 28-7615395 N6910NThornton Michael W · Clinton, NCBuilt 1968 · S/N 680137 N6910UEmbrey Quentin S · Beaver Dam, KYBuilt 1964 · S/N 242 N6911HHarbour Aviation LLC · Weatherford, TXBuilt 1975 · S/N 17265639 N6911JJacksonville Airport Authority · Jacksonville, ILBuilt 1976 · S/N 28-7615396 N6911PMalo Blake Ridgway Trustee · Portland, ORBuilt 1985 · S/N 28-8590050 N6912WTop Flight Aviation Snh LLC · Savannah, TNBuilt 1965 · S/N 28-21287 N6913BKeyt Jeffrey D · New Providence, NJBuilt 1956 · S/N 22-4188 N6913JFlight Time LLC · Conover, NCBuilt 1976 · S/N 28-7690428 N6913NJennings William A · North Little Rock, ARBuilt 1968 · S/N 680138 N6913RAirplane And Drone Flight Instruction LLC · Orlando, FLBuilt 1985 · S/N 28-8590054 N6913UShaw Brian D · Meadville, PABuilt 1964 · S/N 245 N6913WAden James D · Gothenburg, NEBuilt 1965 · S/N 28-21288 N6914BLark Bradley J · Enoch, UTBuilt 1956 · S/N 22-4189 N6914JKreppel Frederick W · Wayne, PABuilt 1976 · S/N 28-7690429

Back to AD 79-10-03 R2