OpenAirDocs.org
AD 48-06-03

Registered aircraft · 373

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-06-03')
    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-06-03')
  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.

N10133Fisher Charles R Jr · San Antonio, TXBuilt 1948 · S/N NAV-4-1766N105ERSokoloski James J · Lampasas, TXBuilt 1947 · S/N NAV-4-521N109DSBell Bradley L · Bothell, WABuilt 1948 · S/N NAV-4-1373N111KMJohnston Cheryle L · El Centro, CABuilt 1946 · S/N NAV-4-324N118AANorthern Valley Air Ltd LLC · Long Island, KSS/N NAV-4-110N124RMGolden Dreams LLC · Missoula, MTBuilt 1946 · S/N NAV-4-136N14SXMiller Randy · Greer, SCBuilt 1946 · S/N NAV-4-416N17VYVallee Jean-Francois R · Everson, WAS/N NAV-4-461N182PGaines Robert M · Nashville, TNBuilt 1956 · S/N NAV-4-1246N1947UTri Pacer Air LLC · Pennington, NJBuilt 1946 · S/N NAV-4-394N225ELetsom Steven D · Eugene, ORBuilt 1948 · S/N NAV-4-1160N225HJMao Darwin · Las Vegas, NVS/N NAV-4-188N22AWare Steven E Trustee · Lonoke, ARBuilt 1946 · S/N NAV-4-19N22VSchadler Alletta M · Fredericksburg, PABuilt 1949 · S/N NAV-4-866N269CCAngeloff Lawren J · Escanaba, MIBuilt 1946 · S/N NAV-4-269N2882DPacific Coast Air Museum · Santa Rosa, CAS/N NAV-4-1938N301Southwest Plane Holdings LLC · Kalispell, MTS/N NAV-4-1167N3178GBrandt Goetz K · San Jose, CABuilt 1947 · S/N NAV-4-861N3374GBangle Delbert F · El Cajon, CABuilt 1948 · S/N NAV-4-1280N4001KZahn Mark V · Sarasota, FLBuilt 1947 · S/N NAV-4-1001N4008KOlson Eric C · Seattle, WABuilt 1947 · S/N NAV-4-1008N4012KKane Robert F · Wilton, CABuilt 1947 · S/N NAV-4-1012N4016KHatch David G · Clovis, CABuilt 1947 · S/N NAV-4-1016N4021KNorthwest Navion Inc · Arlington, WAS/N NAV41021N4026KWarbird Holdings LLC · Middletown, DEBuilt 1947 · S/N NAV-4-1026N4029KCampbelll William Jr T · Sand Springs, OKBuilt 1947 · S/N NAV-4-1029N4043KJackson Ian C · Rochester, NHBuilt 1949 · S/N NAV-4-1043N4045KCincy Warbirds LLC · West Chester, OHBuilt 1947 · S/N NAV-4-1045N4080K80 Kilo LLC · Hammond, LAS/N NAV-4-1080N4101KBravery Aviation LLC · Viburnum, MOS/N NAV-4-1101N4102KTomlin Rollin D · Wilmington, OHBuilt 1947 · S/N NAV-4-1102N4110KDdrl Holdings LLC · Missoula, MTBuilt 1947 · S/N NAV-4-1110N4111KMillar Charles R · Maricopa, AZS/N NAV-4-1111N4124KOtt Dean R · Carrollton, OHBuilt 1947 · S/N NAV-4-1124N4126KNichols Jan L · Bonham, TXS/N NAV-4-1126N4130KColvin Buster · Big Cabin, OKS/N NAV-4-1130N4132KJohnston William D · Visalia, CAS/N NAV41132N4135KBurlace Thomas J III · Aurora, COBuilt 1948 · S/N NAV-4-1135N4139KStone Jason · Wellington, KSS/N NAV-4-1139N4143KDerickson Russell J · Lamberton, MNBuilt 1948 · S/N NAV-4-1143N4145KGerondale Gregory · Tulsa, OKS/N NAV-4-1145N4146KHolmes Peter N · Spokane, WABuilt 1948 · S/N NAV-4-1146N4150KTomlin Rollin D · Wilmington, OHBuilt 1949 · S/N NAV-4-1150N4156KLohse Charles R · Onalaska, WAS/N NAV-4-1156N4158KHester Jesse S · Mclean, VAS/N NAV-4-1158N4169KAndersen Nicholas · Logan, UTS/N NAV-4-1169N4183KGroth Matthew C · Arlington, WABuilt 1948 · S/N NAV-4-1183N4185KKennedy John E · Martinsville, INBuilt 1948 · S/N NAV-4-1185N4188KMartino Victor H · Port Wentworth, GABuilt 1948 · S/N NAV-4-1188N4190KPflaum Dudley T Trustee · Henderson, NVBuilt 1948 · S/N NAV-4-1190
Back to AD 48-06-03