AD 48-07-01

Registered aircraft · 2,265

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-07-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-07-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.

N1859VKorson James J · Yorkville, ILBuilt 1947 · S/N 14038N1860VNuckles Charles A Jr · Suffolk, VABuilt 1947 · S/N 14039N1863VSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1947 · S/N 14043N1866NSpivey Darwyn D · Guntersville, ALS/N 12110N1867NPasqualino Mark W · Ocala, FLBuilt 1946 · S/N 12111N1872VPlane Fun Inc Tr Trustee · Snellville, GABuilt 1947 · S/N 14052N1873NBarbee Max C · Wharton, TXBuilt 1946 · S/N 12117N1874NCuddie Robert R · Marble Falls, TXBuilt 1946 · S/N 12118N1874VRaczynski Adam · Far Rockaway, NYS/N 14054N1875VTigger LLC · Missoula, MTBuilt 1947 · S/N 14055N1877NAscolese Michael J · Athol, MABuilt 1946 · S/N 12121N1877VHickman Robert J · Canby, ORBuilt 1947 · S/N 14057N1879VAnderson Marshall C · Jacobson, MNBuilt 1947 · S/N 14059N1881VSimonson Todd D · Minnetonka, MNBuilt 1947 · S/N 14061N1882VBell William F · Peachtree Corners, GABuilt 1947 · S/N 14062N1883NStrand Stephen E · Pelican Rapids, MNBuilt 1946 · S/N 12127N1888NMorton William J · Hurst, TXBuilt 1947 · S/N 12132N1888VMiller Thomas Lee · Clemmons, NCBuilt 1947 · S/N 14068N1890NVasquez Allison O · San Antonio, TXS/N 12134N1891NMcmaster James R II · Bath, PABuilt 1947 · S/N 12135N1894NWarren C Metzger II · Anchorage, AKBuilt 1947 · S/N 12138N1894VKohlert Jeffrey R · Saint Charles, ILBuilt 1947 · S/N 14083N1895VMontgomery Larry G · Seymour, INFirst renewal noticeBuilt 1947 · S/N 14085N1897NNasw Foundation · Rio Grande, NJBuilt 1947 · S/N 12141N1901NHowerton Bradley S · Bartlesville, OKBuilt 1947 · S/N 12145N1903VCovelli Rene A · Cherry Hill, NJBuilt 1947 · S/N 14094N1906NBourland Alton L · Santa Teresa, NMBuilt 1947 · S/N 12150N1907VChristopher Russell L · Leona Valley, CABuilt 1947 · S/N 14099N1909NSanders David L · Powell, WYBuilt 1947 · S/N 12153N1910VBommarito Sterling J · Bend, ORS/N 14103N1912VWatson Bryan · Kent, WABuilt 1947 · S/N 14105N1916VSuter William A · Bluffton, OHBuilt 1947 · S/N 14110N1917NLozano Brian · Santa Rosa, CAS/N 12161N1917VJustice Thomas J · Wilmington, NCBuilt 1947 · S/N 14111N1920VTruluck Charles Harry III · North Fort Myers, FLBuilt 1947 · S/N 14116N1925VNewell Robert J Jr · Belleville, MIBuilt 1947 · S/N 14123N1926VVeenstra Timothy S · Wasilla, AKBuilt 1947 · S/N 14124N1927VBoydston Terry · Whitewater, WIBuilt 1947 · S/N 14127N1928NNikkila John C · Surprise, AZBuilt 1947 · S/N 12172N1928VSchubert Christopher P · Canandaigua, NYBuilt 1947 · S/N 14128N1935NAscolese Michael J · Athol, MABuilt 1947 · S/N 12175N1938VBarnett Jeffrey S · Clayton, INBuilt 1947 · S/N 14142N1939VWheadon William J · Napa, CABuilt 1947 · S/N 14145N1940VGregg Delvin K · Durango, COS/N 14146N1944NNentwick James L Jr · East Liverpool, OHS/N 12184N1945NCochran Clifford D · Soldotna, AKBuilt 1947 · S/N 12185N1945VKellar John C · Runaway Bay, TXBuilt 1947 · S/N 14153N1947VKlenske Joshua Mark · Yucaipa, CAS/N 14239N1947ZPanzer Jessica DBA · Lincoln, NEBuilt 1947 · S/N 13718N1948VBryant Mark A · Bennett, COBuilt 1947 · S/N 14159
Back to AD 48-07-01