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.

N1790VThompson Randy L · Anderson, CABuilt 1947 · S/N 14023N1791NKieser Jason P · Bloomington, ILBuilt 1946 · S/N 12035N1792VScholz Paul W · Clifton Park, NYBuilt 1948 · S/N 14520N1793NDaigh Eric B · Ketchum, IDS/N 12027N1794NRedsun Oren D · Fairfield, CABuilt 1946 · S/N 12038N1795NBeckham Joseph D · New Waverly, TXBuilt 1946 · S/N 12039N1797NStrebel David P · Oroville, CABuilt 1946 · S/N 12041N1797VValle Perez Kevin · Castroville, TXBuilt 1947 · S/N 13982N1798NHissam Joshua K · Pasco, WAS/N 12042N1798VBolton Derwin B · Jacksonville, TXBuilt 1947 · S/N 13983N1803VAnderson Michael J · Carmichael, CABuilt 1947 · S/N 13988N1805NThompson Randy L · Anderson, CABuilt 1946 · S/N 12049N1806VBrown Christopher · Mancelona, MIBuilt 1947 · S/N 13991N1807VBushre David N · Janesville, WIBuilt 1947 · S/N 13992N1808VReller Bernard D · Gainesville, FLBuilt 1947 · S/N 13993N1810NMetzler Darwin H · Manheim, PABuilt 1946 · S/N 12054N1812NRutherford Kevin · Sheridan, ARBuilt 1946 · S/N 12056N1813VCodingflyboy LLC · Hayward, CAS/N 13998N1817VHarper James J · Miller, MOBuilt 1947 · S/N 14002N1818NFirth Thomas H IV · Sonora, CABuilt 1946 · S/N 12062N1819NPower Terry Edward · Council, IDBuilt 1946 · S/N 12063N1819VSparebanc LLC · Appleton, MNBuilt 1947 · S/N 14004N1823NMoehn Dennis H · Oshkosh, WIS/N 12067N1823VWeller Oscar R · Sun City, AZBuilt 1947 · S/N 14150N1826NHenry Dean R · Gilroy, CABuilt 1946 · S/N 12070N1827NBrooks Adam Jacob Robert · Granada Hills, CABuilt 1946 · S/N 12071N1827VAgate Mark A · Phoenix, AZBuilt 1947 · S/N 14045N1829NEvans Earl J · Oglethorpe, GABuilt 1948 · S/N 12073N1829VJacob Mark K · East Lansing, MIBuilt 1947 · S/N 14047N1834NBernard Elswick Theodore · Fernley, NVBuilt 1946 · S/N 12078N1835VHauser Linda L · Ulysses, KSBuilt 1947 · S/N 14074N1836NMulligan Kevin S · Port Alexander, AKBuilt 1946 · S/N 12080N1838NMutual Flyers Inc · Columbus, NEBuilt 1946 · S/N 12082N1838VRegistered aircraftBuilt 1947 · S/N 14015N1839VEdwards Christopher V · Seattle, WAS/N 14084N1840NBybee James W · West Jordan, UTBuilt 1946 · S/N 12084N1843NMaples Andrew L · Belle, MOBuilt 1946 · S/N 12087N1843VFrostman Ronald G · Ft Myers, FLBuilt 1947 · S/N 14096N1844NCorn Dustin M · Muncie, INBuilt 1946 · S/N 12088N1844VWheelock Jon M · Fairbanks, AKS/N 14102N1845NLoucks Donald A · Bastrop, TXBuilt 1946 · S/N 12089N1847NO'Quinn Aaron N · Anchorage, AKS/N 12091N1848VGray William G · Littlefork, MNBuilt 1947 · S/N 14019N1849VCooke Patrick E · Wrightsville, PABuilt 1947 · S/N 14114N1850VHudson Dave C Jr · Sumrall, MSBuilt 1947 · S/N 14020N1851VKraemer Norma J · Deadwood, SDBuilt 1947 · S/N 14119N1853NProst Gary E · Stockton, CAS/N 12097N1853VMid Michigan Aviation LLC · Owosso, MIBuilt 1947 · S/N 14125N1856CJones Mark S · Tampa, FLBuilt 1946 · S/N 8996N1858NWeeks Addison W · Covina, CABuilt 1946 · S/N 12102
Back to AD 48-07-01