OpenAirDocs.org
AD 78-16-06

Registered aircraft · 896

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:78-16-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:78-16-06')
  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-582N118GBBas Part Sales LLC · Greeley, COS/N MC-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-232N1820GGarcia Ted A · Carefree, AZBuilt 1981 · S/N MC-702N1821BBonney Andrew · Marion, MABuilt 1976 · S/N M-1907N1822XRegistered aircraftBuilt 1981 · S/N M-2327N1824PHoffman Warren S · East Meadow, NYBuilt 1981 · S/N MC-759N1824XKepo Aviation LLC · Ball, LABuilt 1981 · S/N MC-760N18251Rushing Daniel W III · Inlet Beach, FLS/N M-2329N1827ZGray Amber · Forestville, CABuilt 1981 · S/N MC-762N1831NMargegrace17 LLC · Dayt Bch Sh, FLBuilt 1981 · S/N MC-763N18325Hawkins Randall F · Point Pleasant, WVBuilt 1981 · S/N M-2336N18372N18372 LLC · Kalispell, MTBuilt 1981 · S/N MC-764N1837WChurchill Laurice U · Torrance, CABuilt 1981 · S/N M-2340N18516Maine Instrument Flight · Augusta, MEBuilt 1981 · S/N M-2344N18767Zimmerman Patrick Joseph · Roseburg, ORBuilt 1977 · S/N MC-503N18769Shiel Penny S · Palisade, COBuilt 1977 · S/N MC-500N18770Robinson Jere L · Burnet, TXS/N MC-498N18774Sarasota Avionics Inc · Venice, FLBuilt 1977 · S/N M-1941N18775Chesley Boyd A · Cottonwood, AZS/N MB-846N18782Stagman Andrew A · Land O Lakes, FLBuilt 1977 · S/N MC-505N18783Bates 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-1942N18793Berns Robert D · Clifton, ILBuilt 1977 · S/N MC-506N18795Bock Patrick D · Phoenix, AZBuilt 1977 · S/N M-1947N18798Herald Jason E · Tulsa, OKBuilt 1977 · S/N MC-508N18841Quality Aviation Inc · Atlanta, GABuilt 1977 · S/N MC-509N18858Martindale Ian C · Seattle, WABuilt 1977 · S/N MC-510N18859Molnair LLC · Columbus, GABuilt 1977 · S/N MC-511N18861Phillips 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-1955N18865Shoreline Aviation LLC · Norman, OKBuilt 1977 · S/N MC-514
Back to AD 78-16-06