OpenAirDocs.org
AD 88-10-01

Registered aircraft · 463

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:88-10-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:88-10-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.

N1013PSentinel Services Group LLC · Brooksville, FLS/N MC-428N101CMKuhns Robert M · Wichita, KSBuilt 1973 · S/N MC-146N103RGTupelo Aeronautics Inc · Tupelo, MSBuilt 1975 · S/N MC358N104DBPryce Gerald · Independence, ORBuilt 1974 · S/N MC-309N104GDFiebiger Mark D · Leesburg, FLBuilt 1970 · S/N MC-49N118GBBas Part Sales LLC · Greeley, COS/N MC-582N164DAAv Beech Holding LLC · Mandeville, LABuilt 1966 · S/N MA-101N167SDierenfeldt William Travis · Manhattan, KSS/N MC-18N16956Hollowell Baron J · Boise, IDS/N MC-132N1800PRegistered aircraftBuilt 1968 · S/N MA-326N1820GGarcia Ted A · Carefree, AZBuilt 1981 · S/N MC-702N1824PHoffman Warren S · East Meadow, NYBuilt 1981 · S/N MC-759N1824XKepo Aviation LLC · Ball, LABuilt 1981 · S/N MC-760N1827ZGray Amber · Forestville, CABuilt 1981 · S/N MC-762N1831NMargegrace17 LLC · Dayt Bch Sh, FLBuilt 1981 · S/N MC-763N18372N18372 LLC · Kalispell, MTBuilt 1981 · S/N MC-764N18767Zimmerman Patrick Joseph · Roseburg, ORBuilt 1977 · S/N MC-503N18769Shiel Penny S · Palisade, COBuilt 1977 · S/N MC-500N18770Robinson Jere L · Burnet, TXS/N MC-498N18782Stagman Andrew A · Land O Lakes, FLBuilt 1977 · S/N MC-505N18793Berns Robert D · Clifton, ILBuilt 1977 · S/N MC-506N18798Herald 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-511N18865Shoreline Aviation LLC · Norman, OKBuilt 1977 · S/N MC-514N18874Registration Pending · Pantego, NCRegistration pendingBuilt 1977 · S/N MC-518N18887Clifford Royce Ellen · Leucadia, CABuilt 1977 · S/N MC-519N18909Thomas William Tyler · Athens, TNBuilt 1977 · S/N MC-524N18930Trustgroup Aircraft Hangar Sales LLC · Metairie, LABuilt 1977 · S/N MC-527N18934Gray Van D · Woodway, TXBuilt 1977 · S/N MC-530N18938Hangar 5 LLC · Williamsburg, VABuilt 1977 · S/N MC-531N18940Mella Aviation LLC · Tucson, AZBuilt 1977 · S/N MC-532N18950Osgood James G · Columbia, MOBuilt 1977 · S/N MC-535N18951Evans Lynn · Vici, OKBuilt 1977 · S/N MC-536N18959Rushton Damion · Ellenwood, GABuilt 1977 · S/N MC-539N18974Carbon County Oncology Management Inc · Auburn, PABuilt 1977 · S/N MC-542N18981K V Aviation Ltd · Greenfield, INBuilt 1977 · S/N MC-545N18987Bhr Aviation Inc · Potomac, MDBuilt 1979 · S/N MC-546N18993Ochs Mark A · Madison, MSBuilt 1977 · S/N MC-550N18996Black Bennett · Hansville, SCBuilt 1977 · S/N MC-553N1929LIngstad Eric Charles · Lakewood, CABuilt 1976 · S/N MC-416N1933LN1933l Ltd · Streetsboro, OHBuilt 1976 · S/N MC-417N1937LLuks George J · Crescent City, CABuilt 1976 · S/N MC-419N1938LTexas Environmental Training & Compliance LLC · Frost, TXBuilt 1976 · S/N MC-414N1939LCook Kenneth T · Danielson, CTBuilt 1976 · S/N MC-418N1942LN1942l LLC · Wichita, KSBuilt 1976 · S/N MC-415N1953LWyatt Shawn D · Fort Worth, TXBuilt 1976 · S/N MC-421N1957LSmith Joseph M · Ames, IABuilt 1976 · S/N MC-423N1960LButler David · Palos Park, ILBuilt 1976 · S/N MC-422
Back to AD 88-10-01