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.

N140KYCarpenter Michael A · Jefferson, ORBuilt 1946 · S/N 11780N140LBBerry Brian R · Tahlequah, OKBuilt 1946 · S/N 10677N140LDMazankowski Lara R · San Diego, CABuilt 1946 · S/N 10929N140MENorah Bridget · Snoqualmie, WABuilt 1946 · S/N 8044N140MTHoover Josiah E · Wasilla, AKBuilt 1947 · S/N 12905N140MWWeyant Charles B · Santa Maria, CAS/N 9845N140NJames Justin C · Pima, AZBuilt 1947 · S/N 14026N140NSSwann Neal P · Plymouth, CAS/N 14908N140PClass A Coaches LLC · Missoula, MTBuilt 1947 · S/N 13855N140PRBlue Sky Air LLC · Queen Creek, AZBuilt 1946 · S/N 9440N140QSchroeder Peter G · Clemmons, NCBuilt 1946 · S/N 9748N140SGGault Scott J · Norcross, GABuilt 1946 · S/N 11573N140SKRon Alexander Youth Aviation Program · Williamson, GABuilt 1947 · S/N 12835N140TGRounds Chris · Waller, TXBuilt 1946 · S/N 9433N140TJSetter Thomas D · Burnsville, MNS/N 12645N140TMKauffman Marvin Paul · Brooksville, MSS/N 10580N140TWRegistration Pending · Burlington, NCRegistration pending, pending cancellationBuilt 1947 · S/N 12403N140VMaggart Daniel J · Winchester, ILS/N 14291N140WYWilson J Brent Trustee · Lander, WYBuilt 1947 · S/N 12865N140XRegistration Pending · Scottsbluff, NERegistration pendingS/N 11387N140YABeineke Paul R · Marion, OHBuilt 1946 · S/N 10993N146FTTavener Frederick L · Cape May, NJBuilt 1946 · S/N 11303N146VSchmidt Aaron Joseph · Bisbee, AZS/N 11566N149JASummers Dennis L · Perry, OKBuilt 1948 · S/N 14937N1508UKnefley J Michael · Ulysses, PABuilt 1948 · S/N 14995N150RBailey Richard N · Danville, VABuilt 1948 · S/N 14441N154DGFisher Jeffrey L · Thorndale, TXBuilt 1947 · S/N 12621N1600KDenzil Charles David · Southmayd, TXBuilt 1946 · S/N 8639N1601VIte LLC · St Pete Beach, FLS/N 13773N1604VShuel Dale W · Brighton, COBuilt 1947 · S/N 13776N1605VLindsey Allie Ayers · Lamont, OKBuilt 1947 · S/N 13777N1606VWeatherproof Montana LLC · Missoula, MTBuilt 1947 · S/N 13778N1610VSale Reported · Lisbon, OHSale reportedBuilt 1947 · S/N 13782N1611VRevak Ben · Dousman, WIBuilt 1947 · S/N 13783N1612VQuan Justin · Ventura, CABuilt 1947 · S/N 13784N1619VCushway Amos · Anchorage, AKS/N 13791N1624VSmith John C · Greenville, NCBuilt 1947 · S/N 13796N1627VSmith Eric M · Sanger, TXFirst renewal noticeBuilt 1947 · S/N 13799N1630VBaeseman Alex J · Moab, UTBuilt 1949 · S/N 13802N1636VMoeser David P · Colton, ORBuilt 1947 · S/N 13808N1645VBode Theodore Wayne · Potosi, WIBuilt 1947 · S/N 13817N1646VTodd Doug A · De Witt, IAS/N 13818N1649VLaforce Larry B · Big Sandy, TXBuilt 1947 · S/N 13821N1651VKistler Harvey S · Colby, KSBuilt 1947 · S/N 13823N1656VCobb Raymond E · Highland, CABuilt 1947 · S/N 13828N1661VWeggel Roger · Fairbanks, AKS/N 13833N1662VLauer Donald Robert · Prospect, OHBuilt 1947 · S/N 13834N1663VBryant George R · Gainesville, TXBuilt 1947 · S/N 13835N1670VHale Justin A · Cheyenne, WYS/N 13842N1671VHarris James J · Saint Marys, OHBuilt 1947 · S/N 13843
Back to AD 48-07-01