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.

N7155QValley Ltd Of Fayetteville · Fayetteville, NCBuilt 1972 · S/N 17260455N7155RVander Ploeg Robert · Sebring, FLBuilt 1966 · S/N 28-21862N71563Treml Edward I · Kewaunee, WIBuilt 1990 · S/N 238N7156BJstream Lc · Sheridan, WYS/N 22-4381N7156DWilliams Eron T · Overbrook, KSBuilt 1957 · S/N 22-5020N7156LExcalibur Aviation LLC · Amelia Court House, VABuilt 1973 · S/N AA5-0456N7156QAmerican Patrols Inc · Midland, TXBuilt 1972 · S/N 17260456N7156RBlair Marianne T · Waynesboro, VABuilt 1966 · S/N 28-21863N7156ZClum David V · Anchorage, AKBuilt 1965 · S/N 18-8270N7157DNewgent Isaac T · Westminster, MDBuilt 1957 · S/N 22-5021N7157GAero Quest LLC · Olive Branch, MSBuilt 1969 · S/N 17258857N7157LZuwerink Michael J · Holton, MIBuilt 1973 · S/N AA5-0457N7157ZUrstadt Christopher M · Girdwood, AKS/N 18-1066N7158CAeronauts Flying Club Inc · Newton, MABuilt 1975 · S/N 28-7690057N7158DTotal Flight Aircraft Leasing LLC · Apex, NCBuilt 2004 · S/N 3721N7158GHawk Aviation Inc · Rush City, MNBuilt 1969 · S/N 17258858N7158LSears Wes L · Tacoma, WABuilt 1973 · S/N AA5-0458N7158PJinnette James · Raleigh, NCBuilt 1963 · S/N 175N7158RVenango Regional Aero Group Inc · Franklin, PABuilt 1966 · S/N 28-21866N7158SHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 2004 · S/N 3689N7159GN7159g LLC · Jacksonville, ARS/N 17258859N7159LRowlett Roger S · Hamilton, NYBuilt 1973 · S/N AA5-0459N7159WBami LLC · Clymer, PABuilt 1963 · S/N 28-967N715BFPlante Dennis M · Woodway, TXBuilt 1967 · S/N 28-4084N715CWWoodin Christopher · Groveland, FLBuilt 1969 · S/N 28-25786N715FLTaylor Kennedy F · Courtland, MSBuilt 1972 · S/N 28-7225355N715GHodge Cle'Jae J · St Thomas, VIBuilt 1980 · S/N 172RG0653N715MBS&M Aircraft LLC · Harmony, PAS/N M-II-715MBN715RRegistered aircraftBuilt 1994 · S/N 1N715RBFirst Love LLC · Sterling, AKBuilt 1977 · S/N 18-7709198N715SBDahmes Ronald M · Eagan, MNS/N 2051N7160DDrain Alan K · Columbus, MTBuilt 1957 · S/N 18-5610N7160GFisher Noel F · Petersham, MABuilt 1969 · S/N 17258860N7160LHuntley Michael E · Sonora, CAS/N AA5-0460N7160QPhoenix Aviation LLC · Meridian, IDBuilt 1972 · S/N 17260460N7160WWillis Alvin · Cheyenne, WYBuilt 1963 · S/N 28-968N7161GJohnson Robert D · Denver, PABuilt 1969 · S/N 17258861N7161QFrigate Aviation LLC · Smithville, OHBuilt 1972 · S/N 17260461N7161RMilner David V · Long Valley, NJBuilt 1966 · S/N 28-21869N7161UJones Barkley · Moultrie, GABuilt 1964 · S/N 2743N7161WWhiskey Foxtrot Alpha LLC · Hartford, KYBuilt 1963 · S/N 28-969N7162GWmg Security · Shelton, WAS/N 17258862N7162UEcklund Scott Trustee · Brandon, SDBuilt 1964 · S/N 2744N7162WBowers Gary Michael · Denton, TXBuilt 1962 · S/N 28-935N7163CCovington Jeremiah · Fortuna, CABuilt 1975 · S/N 28-7625071N7163DLaub-Elkins Jessie · Wasilla, AKS/N 18-5617N7163GDs Flight Services LLC · Battle Ground, WABuilt 1969 · S/N 17258863N7163LKandybowski Steven J · Tower City, PABuilt 1973 · S/N AA5-0463N7163RRushing Christopher P · Auburndale, FLS/N 28-21872N7163UPatterson John M II · Frankfort, KYBuilt 1964 · S/N 2745
Back to AD 79-10-03 R2