AD 48-08-01

Registered aircraft · 1,077

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:48-08-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:48-08-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.

N1490GSmith David Brian · Indianapolis, INBuilt 1962 · S/N CD-476N1499GCrist Michael Alan · Wakonda, SDBuilt 1962 · S/N CD-480N1505ZKc Air LLC · Wellford, SCBuilt 1962 · S/N CD-542N1506ZTopspeed Black LLC · Alpharetta, GABuilt 1961 · S/N CD-395N1513SHoward Michael G · Slaughters, KYBuilt 1962 · S/N CD-473N1517ZFreedom Aviation LLC · Beaufort, SCBuilt 1961 · S/N CD-412N1519SSimmons Gene R · Vicksburg, MIFirst renewal noticeBuilt 1962 · S/N CD-498N1522S1522s LLC · Sikeston, MOBuilt 1962 · S/N CD-503N1523SMeece Edward B · Portland, ORBuilt 1962 · S/N CD-504N1524SFaris Garold D · Bay City, TXBuilt 1962 · S/N CD-496N1541ZDebonair Inc · Kansas City, MOS/N CD-421N1545SAnthony Joan Lissan · Baxter, TNBuilt 1962 · S/N CD-522N1547ZDowning Darren J · Knoxville, TNBuilt 1961 · S/N CD-423N1550ZDemos Gary D · Cable, OHBuilt 1961 · S/N CD-426N1554SBeech Babe Ltd · Colorado Springs, COBuilt 1962 · S/N CD-525N1558ZAlpha Tango Aviation LLC · Gillette, WYBuilt 1961 · S/N CD-428N1563SMiller Edward L · Santa Rosa, CABuilt 1962 · S/N CD-524N1569ZTran Danh · Moreno Valley, CAS/N D-1107N1573SMckee Keith L · Fuquay Varina, NCBuilt 1962 · S/N CD-528N1574SAdk Global LLC · Hollywood, FLBuilt 1962 · S/N CD-530N1574ZFernando Espinosa Aviation LLC · Helena, MTBuilt 1961 · S/N CD-432N1577GCohen Mark R · Dallas, TXBuilt 1967 · S/N CD-1103N1579ZQueen Mark Allen · Adel, GABuilt 1961 · S/N CD-434N157MDDunbar Kevin R · Belmont, NCBuilt 1947 · S/N D-1150N1583SSmythe Errol J DBA · Bixby, OKBuilt 1962 · S/N CD-532N1584SWhitlock Holdings LLC · Honey Grove, TXBuilt 1962 · S/N CD-534N1586SWits End Travels Ltd · Wilmington, DEBuilt 1962 · S/N CD-535N1588SMava Aviation LLC · Fort Worth, TXBuilt 1962 · S/N CD-537N1588ZWalker Wesley F · Rock Hill, SCBuilt 1961 · S/N CD-436N1589SHunton Paul S · Murfreesboro, TNBuilt 1962 · S/N CD-538N1589ZRiester Bernard J Jr · Auburn, NYBuilt 1961 · S/N CD-437N1592SRoach Christopher A · Mustang, OKBuilt 1962 · S/N CD-471N1597SJones William F · Seneca, SCBuilt 1962 · S/N CD-540N1599VQuigley Ryan P · Chemung, NYBuilt 1947 · S/N D-55N15DLSchlund Bradley D · Springtown, TXS/N CD-375N15MEnglish Dexter · Syracuse, KSBuilt 1964 · S/N CD-794N15NCHerberg Hayley · Reno, NVBuilt 1966 · S/N CE-12N162MDD Squared Aviation LLC · Fort Worth, TXBuilt 1965 · S/N CD-995N1643TWilliams Rudder · Scottsboro, ALBuilt 1965 · S/N CD-989N165MRDavid Rever Aviation LLC · Dewey Beach, DEBuilt 1962 · S/N CD-459N167MStoltzfus Jesse A · Greenfield, OHBuilt 1964 · S/N CD-795N168NLLakeside Views LLC · La Crescenta, CABuilt 1966 · S/N CE-45N169PHunter James F · Sevierville, TNBuilt 1947 · S/N D-815N1705GDavis Roger N · Cheshire, ORBuilt 1962 · S/N CD-479N1714GBull Rises LLC · Byron Center, MIS/N CD-482N1718GWhitlock Charles Parker · Thompsons Station, TNBuilt 1962 · S/N CD-481N1723GDillahunty Chris D · Shaver Lake, CAS/N CD-486N1724GNelson Debra L · Presque Isle, MEBuilt 1962 · S/N CD-487N1735GFeldhaus Joseph H · Shelbyville, TNBuilt 1962 · S/N CD-489N1740GOelrich Matthew Alan · Concord, CABuilt 1962 · S/N CD-490
Back to AD 48-08-01