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.

N1672VKott Edward A · Lake City, FLS/N 13844N1682VShuck Michael W Trustee · Maize, KSBuilt 1947 · S/N 13854N1685VCreglow Jacob A · Soldotna, AKS/N 13857N1686VByers Ricky A · Hereford, AZBuilt 1947 · S/N 13858N1695VAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1947 · S/N 13867N1696VRonnau Thomas F · Kansas City, KSBuilt 1946 · S/N 13868N1703NEvans Richard H Sr · Holt, FLFirst renewal noticeS/N 11947N1704VFigure 1 Foundation · Los Angeles, CABuilt 1948 · S/N 13889N1706VHermann Christine F · Radford, VABuilt 1947 · S/N 13891N1708UShelton Philip C · Wise, VABuilt 1947 · S/N 12160N1708VMock Paul M · Williams, AZBuilt 1947 · S/N 13893N1710VWanda Collins Professional Pilot Services LLC · Madisonville, TXBuilt 1947 · S/N 13895N1712NPinger Kevin R · Palo Alto, CABuilt 1946 · S/N 11956N1715NGerzevitz Robert M · San Diego, CABuilt 1948 · S/N 11959N1717NDagenhart Kagan · Midland, TXBuilt 1946 · S/N 11961N1720VEdmonds Sherry B · Georges Mills, NHBuilt 1947 · S/N 13905N1721NWood Bokman Janine · Athol, IDBuilt 1946 · S/N 11965N1721VCollins Gary C · Asheboro, NCBuilt 1947 · S/N 13906N1722VLittle Bird Aviation · Abiquiu, NMBuilt 1947 · S/N 13907N1724NTurcott Joshua A · Stockton, CAS/N 11968N1726NGranneman William L · Costa Mesa, CABuilt 1946 · S/N 11970N1726VBosquet Arthur · Highgate Center, VTS/N 14034N1728VMoore Edward L · Hixson, TNBuilt 1947 · S/N 13913N1731VHargrove Dwayne E · Shepherdsville, KYBuilt 1947 · S/N 13916N1741NAero Optics Inc · Aguila, AZBuilt 1946 · S/N 11985N1741VCollins E Randolph · Clemson, SCFirst renewal noticeBuilt 1947 · S/N 13926N1745VReinholtz Edward J · Glasford, ILBuilt 1947 · S/N 13930N1746NSmith Courtney E · Phoenix, AZBuilt 1946 · S/N 11990N1748NTengesdal Kenneth L · Maxbass, NDBuilt 1946 · S/N 11992N1751NTynes Edward R · Round Rock, TXBuilt 1946 · S/N 11995N1751VScott William G · Lebanon, ORBuilt 1947 · S/N 13936N1754NMorrison Rodney R · Hot Springs, ARBuilt 1946 · S/N 11998N1755VMcclean James · Springfield, MOBuilt 1947 · S/N 13940N1757VMollohan Timothy J · Otis, COBuilt 1947 · S/N 14138N1758NMclaughlin James L · Centerburg, OHS/N 12002N1761NNewcomer Ryan D · Monroe, GABuilt 1946 · S/N 12005N1761VMoyer Michael R · Elkton, MDBuilt 1947 · S/N 13946N1766NStevens William · Nassau Bay, TXBuilt 1946 · S/N 12010N1767VHanson Jonathan G · Nome, AKS/N 14151N1770NWirth Curtis L · New Raymer, COBuilt 1946 · S/N 12014N1771NRohsner Thomas A · Nacogdoches, TXBuilt 1946 · S/N 12015N1773NRhoades William P · Northfield, MNBuilt 1946 · S/N 12017N1773VGilbert Mary L · Memphis, NYS/N 13958N1775NPritchard Joshua E · Andover, KSBuilt 1946 · S/N 12019N1776VNelson Richard W · Edna, TXBuilt 1947 · S/N 13961N1778VWatkins James R · Granbury, TXBuilt 1947 · S/N 13963N1783VMark Uhlman Dpe LLC · Perry, OKBuilt 1947 · S/N 13968N1784VHarlow Nathan D · Milton, VTBuilt 1947 · S/N 13969N1786NLivingston Lyle R · Chico, CABuilt 1946 · S/N 12030N1788NLahti Matt · Waterford, MIBuilt 1946 · S/N 12032
Back to AD 48-07-01