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.

N5872QAir Mods And Repair Inc · Robbinsville, NJBuilt 1965 · S/N 3144N5873WPropst David A · Exchange, WVS/N 28-2503N5874UFlying Wright Aviation LLC · Henderson, NVS/N 28-26707N5875UTews Jamie S · Greenville, WIBuilt 1970 · S/N 28-26708N5875VCrew Michael A · Phoenix, AZBuilt 1977 · S/N 28-7716209N5876DKirkendall James · N Richlnd Hls, TXBuilt 1956 · S/N 22-4557N5876LWilson James · Bagwell, TXS/N AA5-0276N5876U3shahs Aviation LLC · Temecula, CAS/N 28-26709N5876WKiss George C · Bangor, PAS/N 28-2552N5877FFeldvary John · Jackson, MIBuilt 1976 · S/N 28-7715155N5877LFlyboys Aviation LLC · Sioux City, IABuilt 1972 · S/N AA5-0077N5877VWest Keith W · Slatington, PABuilt 1977 · S/N 28-7790505N5878LGomez Blanco Rafael · Lakewood, CABuilt 1972 · S/N AA5-0078N5878UAlbright Jasper N · Raleigh, NCBuilt 1970 · S/N 28-26710N5878WWorrell Wayne · Campbellsville, KYBuilt 1965 · S/N 28-2555N5879LN5879l LLC · Lewes, DEBuilt 1972 · S/N AA5-0229N5879UJacobs Levon Jr · Oak Hill, FLBuilt 1970 · S/N 28-26713N587MALong Island Aviators LLC · Seaford, NYBuilt 2002 · S/N 2843517N587PAVan Hatten Michael Sr · Fairbanks, AKBuilt 1989 · S/N 1809033N587WPLindner James F · Williamsburg, MIBuilt 2013 · S/N 62-123/124-868N5880ENashville Skyscrapers LLC · Old Hickory, TNBuilt 1978 · S/N 17271950N5880QSeely Scott · Edmond, OKBuilt 1965 · S/N 3148N5880WDurkin Michael T · Sunland, CABuilt 1965 · S/N 28-2570N5881DKanooth Michael L · Washougal, WABuilt 1956 · S/N 18-5305N5881URegistered aircraftBuilt 1970 · S/N 28-26715N5882FGo Fly Mi LLC · Saginaw, MIBuilt 1976 · S/N 28-7790140N5882LBreazeale Peter · Orangeburg, SCBuilt 1972 · S/N AA5-0082N5882PEvans Gene · Henderson, TXBuilt 1959 · S/N 24-967N5882QBean Merton H III · Phoenix, AZBuilt 1965 · S/N 3149N5882UMartinez Guillermo E · Upland, CABuilt 1970 · S/N 28-26716N5883LOst Kenneth Alan · Langhorne, PABuilt 1972 · S/N AA5-0088N5884DMcmahan Johnny W · Gakona, AKBuilt 1956 · S/N 18-5308N5884QOasis Aero Inc · Willmar, MNS/N 3150N5884UB & R Aircraft LLC · Wadsworth, OHS/N 28-26719N5885DConatser Shawn C · Fairbanks, AKBuilt 1956 · S/N 18-5309N5885PCostanzo Christopher P · Staten Island, NYBuilt 1959 · S/N 24-970N5886DAg Solutions Of West Texas LLC · Roby, TXBuilt 1959 · S/N 18-5310N5886H86h LLC · Burlington, VTBuilt 1949 · S/N 16-503N5886PAce Aeromotive Inc · Miami, FLBuilt 1959 · S/N 24-971N5886XPeak Investments LLC · Roanoke, VABuilt 1994 · S/N 1809088N5887DBragdon James O · Monticello, FLBuilt 1956 · S/N 18-5311N5887UFretz Richard G · Harrisburg, PABuilt 1970 · S/N 28-26722N5888PRegistered aircraftS/N 24-973N5888QCross The Line Sales Inc · Lexington, NCBuilt 1965 · S/N 3152N5888ULynch Francis X · Dumont, NJBuilt 1970 · S/N 28-26755N5889L100 Rads Corporation · Omaha, NES/N AA5-0089N5889RPatkotak Crawford A · Barrow, AKS/N 17253558N5889VRegistration Pending · Cherry Hill, NJRegistration pendingBuilt 1977 · S/N 28-7790507N5889WHarrison Joshua · Canyon Country, CABuilt 1965 · S/N 28-2627N588LESmith Jason E · Calliham, TXBuilt 2004 · S/N 3588
Back to AD 79-10-03 R2