OpenAirDocs.org
AD 48-28-01

Registered aircraft · 541

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

N101RKettunen Alan C · Ashtabula, OHBuilt 1946 · S/N 2125N102MMZahler Mitchell J · Stillwater, MNS/N 71N1043UClinton Arlys L · Fair Oaks, CABuilt 1946 · S/N 81N10KSMorris Jerry M · Summerville, SCBuilt 1946 · S/N 388N10SSShepherd William S · Sequim, WABuilt 1946 · S/N 203N1117RSchmidt Gail · Florence, COS/N 2008N1122WWittman Dennis K · La Crescenta, CABuilt 1946 · S/N 1234N11HFBell Michael S · Trinity, TXBuilt 1946 · S/N 1191N11LSSmall Robert Lance · Fredericksburg, TXBuilt 1946 · S/N 1296N121HPPk Flyer LLC · Lancaster, CABuilt 1956 · S/N 3643N131WBrown Jordan Ray · Center Point, INBuilt 1946 · S/N 359N157TCBengtson Todd D · Tyler, TXBuilt 1946 · S/N 1101N161SReliant Air LLC · Nashua, NHBuilt 1946 · S/N 1074N17SYSeven Sierra Yankee LLC · Monroeville, PABuilt 1946 · S/N 1277N191KBudd William M · St Simons Island, GABuilt 1946 · S/N 252N1CYSwift Museum Foundation Inc · Athens, TNBuilt 1948 · S/N 3572N20EMartin James P · Sioux City, IABuilt 1946 · S/N 1121N210SXSims Stephen E · Locust Grove, GABuilt 1946 · S/N 394N2115Welsh Christopher M · Oxford, NCS/N 1152N212TTTaylor Thomas A · Littleriver, CABuilt 1946 · S/N 1206N217LPSwift Museum Foundation · Athens, TNBuilt 1946 · S/N 310N21FANikodem James · Crystal Lake, ILBuilt 1950 · S/N 3727N22GWSchneider Dan · Lusby, MDBuilt 1949 · S/N 3726N2300BGoodox LLC · Garden Plain, KSBuilt 1948 · S/N 3600N2301BKing Larry Joe · Quanah, TXBuilt 1948 · S/N 3601N2305BDoyal William T · Visalia, CAS/N 3605N2306BBandrowicz Leon A · Lindenhurst, NYBuilt 1948 · S/N 3606N2307BMoyer Alan L · Perkasie, PABuilt 1948 · S/N 3607N2313BVanreeth Edward D · Huntley, ILBuilt 1948 · S/N 3613N2319BGidzinski Daniel P · Campbellsburg, KYBuilt 1948 · S/N 3619N2320BKuffel Florian L · Seattle, WABuilt 1948 · S/N 3620N2328BAaron Richard · Sussex, NJBuilt 1948 · S/N 3628N2329BCarpino Kevin · Gretna, NEBuilt 1948 · S/N 3629N2330BPeck John A Jr · Shady Shores, TXS/N 3630N2332BBartholomew Don B · Gardnerville, NVBuilt 1948 · S/N 3632N2334BN2334b LLC · Omaha, NEBuilt 1948 · S/N 3634N2335BBradley Gary C · Orchard Park, NYBuilt 1948 · S/N 3635N2336BGibbs Dana Trustee · Arlington, TXBuilt 1948 · S/N 3636N2337BJohnson John Jay · Wasilla, AKBuilt 1978 · S/N 3637N2339BSwanson Gregory R · Huntsville, ALBuilt 1948 · S/N 3639N2349BSwift Museum Foundation Inc · Athens, TNBuilt 1948 · S/N 3649N2350BWhitmore Joel P · Mesquite, NVBuilt 1948 · S/N 3650N2356BHall Noel W · Pinecliffe, COBuilt 1948 · S/N 3656N2360BWilfong David C · Warrenton, VAS/N 3660N2361BCaudell Michael A · Cleveland, GABuilt 1948 · S/N 3661N2362BGist Jimmy L · Horseshoe Bay, TXBuilt 1948 · S/N 3662N2365BKeller Baxter Benjamin · Madison, CTBuilt 1948 · S/N 3665N2367BZahler Mitchell J · Stillwater, MNBuilt 1948 · S/N 3667N2369BCc Motors LLC · Redding, CABuilt 1948 · S/N 3669N2372BKing Larry Joe · Quanah, TXBuilt 1948 · S/N 3672
Back to AD 48-28-01