OpenAirDocs.org
AD 74-05-01

Registered aircraft · 720

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:74-05-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-05-01')
  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.

N100RFN100rf Ghost LLC · Burleson, TXS/N MB580N1013PSentinel Services Group LLC · Brooksville, FLS/N MC-428N103RGTupelo Aeronautics Inc · Tupelo, MSBuilt 1975 · S/N MC358N104DBPryce Gerald · Independence, ORBuilt 1974 · S/N MC-309N113JRGrant Jose A · Jefferson, GABuilt 1975 · S/N M-1615N1150ZLundin Ronny · Brewton, ALS/N MB-582N1223TBeech Club LLC · Meadville, PABuilt 1980 · S/N M-2272N128PTaddeo Brent J · Cumming, GABuilt 1979 · S/N M-2220N132PA2 Supersonic LLC · Ann Arbor, MIS/N M-2194N149PAelick Joel D · Charlotte, NCBuilt 1979 · S/N M-2237N156ASWallwork Robert R III · Wauna, WABuilt 1976 · S/N MB-805N1570RHall Clarence W Jr · Fayetteville, ARS/N M-1368N163GCBartholomew Terry L · Pavilion, NYBuilt 1973 · S/N M-1469N16UTWhite Alan J · Fishersville, VABuilt 1972 · S/N M-1396N174DQSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1981 · S/N M2310N1790UHarris M A · Hartford, KSBuilt 1970 · S/N MB-486N1801EValdes George · Pembroke Pines, FLS/N M-2305N1816ZWestern Anesthesia Assn · Richland, WABuilt 1981 · S/N M-232N1821BBonney Andrew · Marion, MABuilt 1976 · S/N M-1907N1822XRegistered aircraftBuilt 1981 · S/N M-2327N18251Rushing Daniel W III · Inlet Beach, FLS/N M-2329N18325Hawkins Randall F · Point Pleasant, WVBuilt 1981 · S/N M-2336N1837WChurchill Laurice U · Torrance, CABuilt 1981 · S/N M-2340N18516Maine Instrument Flight · Augusta, MEBuilt 1981 · S/N M-2344N18774Sarasota Avionics Inc · Venice, FLBuilt 1977 · S/N M-1941N18775Chesley Boyd A · Cottonwood, AZS/N MB-846N18783Bates Gary D · Niles, MIBuilt 1977 · S/N M-1945N18787Ostrowski Brian Keith · Jerome, MIBuilt 1977 · S/N M-1921N18791Registration Pending · Stevens Point, WIRegistration pendingBuilt 1977 · S/N M-1942N18795Bock Patrick D · Phoenix, AZBuilt 1977 · S/N M-1947N18861Phillips Gary O · San Rafael, CABuilt 1977 · S/N M-1953N18862Koenig Michael · Mooresville, NCBuilt 1977 · S/N M-1956N18864Burnett Robert J · Garden Valley, CABuilt 1977 · S/N M-1955N18867Wisniewski Joseph B · Ormond Beach, FLBuilt 1977 · S/N M-1954N18888Symosko Stephen · Oakdale, PABuilt 1977 · S/N MB-858N18895Jmetic Consulting LLC · Springs, TXBuilt 1977 · S/N M-1963N188BSSmith Brenda S · Livingston, TXBuilt 1977 · S/N MB-873N18918Edc Aviation LLC · Middletown, RIBuilt 1977 · S/N M-1964N18920N18920 LLC · North Canton, OHBuilt 1977 · S/N M-1967N18924Swanson Jackson Van Dorn · Gustavus, AKBuilt 1977 · S/N M-1969N18928Kokkinos Antonios H · Naples, FLBuilt 1977 · S/N M-1966N18932Weber Brandon P · Otsego, MIBuilt 1977 · S/N MB-863N18947Federer Joe E · Crane Hill, ALBuilt 1977 · S/N MB-864N18948Page Don S · Norwood, NCBuilt 1977 · S/N M-1978N18956Hanig Kraig K · Merrill, WIBuilt 1977 · S/N MB-867N18962De Plane LLC · Merrill, WIBuilt 1977 · S/N M-1982N18963Ross James R · Nampa, IDBuilt 1977 · S/N M-1984N18966Big Bend Community College · Moses Lake, WABuilt 1977 · S/N MB-869N18968Budde Michael D · Claremore, OKBuilt 1978 · S/N M-1986N18970Wheatley Consulting LLC · Picayune, MSBuilt 1977 · S/N M-1988
Back to AD 74-05-01