AD 90-04-06 R1

Registered aircraft · 68,377

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:90-04-06-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
  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.

N447BBFerree William M · Stafford Springs, CTBuilt 2017 · S/N 71509N447BDRegistration Pending · Columbia, KYRegistration pendingBuilt 2009 · S/N 60103N447CTHowell Aviation LLC · Orlando, FLS/N 38-82A0041N447ESRegistered aircraftS/N 18280135N447GHorn Rodney L · Friendswood, TXBuilt 2008 · S/N 72825N447HHartz Paul · Lake Suzy, FLBuilt 2002 · S/N 169N447KSPoletto Danny A · Great Falls, MTBuilt 1969 · S/N 28-25439N447PJones Thomas C · Friendswood, TXS/N 108N447RMRocky Mountain College · Billings, MTBuilt 2024 · S/N 28020197N447TCOrange Sky LLC · Naples, FLS/N 006N447TJMiller Timothy J · Hutchinson, MNS/N 12687N447WPWall Cameron J · Enid, OKBuilt 2002 · S/N 5701N44800Schoppe Marc · Durham, NCBuilt 1975 · S/N 28-7505012N44802Page Aviation Services LLC · Fort Myers, FLS/N 28R-7535009N44805Gage Christopher · Truckee, CABuilt 1974 · S/N 28-7525008N44806Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1974 · S/N 28-7515037N4480HStatz Matthias Scott · Madison, WIBuilt 1948 · S/N 15-269N4480JGonzalez Guadalupe G · Atwater, CABuilt 1967 · S/N 28-22896N4480MBush Pilot Inc · Soldotna, AKBuilt 1947 · S/N 12-3431N4480RSoutheastern Minnesota Flying Club Inc · Rochester, MNBuilt 1974 · S/N 17263222N4480SCook Christopher R · Manhattan, KSFirst renewal noticeBuilt 1992 · S/N RV4120951SSN4480TSell Justin L · Lucerne, INBuilt 1972 · S/N 28R-7235067N4480VOrtiz Albert Mike · Redondo Beach, CAS/N 1N4480ZKalisz John B · Newhall, CABuilt 1986 · S/N MI-1213N44817Tokach Nicholas J · Hinckley, OHBuilt 1974 · S/N 28-7525009N4481EChambers David N · Cullman, ALBuilt 1948 · S/N 7DC-103N4481HMurray Gregory T · Napa, CABuilt 1948 · S/N 15-270N4481JMusser Fred R · Severna Park, MDFirst renewal noticeBuilt 1967 · S/N 28-22898N4481TValdes Eusebio · Miami, FLS/N 34-7250108N4481XSpence Johnn · Apache Junction, AZS/N 28-7625042N4481ZTucker Jason M · Wasilla, AKBuilt 1969 · S/N 18-8816N44820Volar Corp · El Cajon, CABuilt 1977 · S/N 28-7816022N44821Josselyn Jeffrey Scott · Midlothian, TXBuilt 1942 · S/N 4488N4482EStaton Stephen D · Soldotna, AKBuilt 1981 · S/N 18-8109025N4482JWebe Properties LLC · Toledo, OHBuilt 1967 · S/N 28-22899N4482MPapon Bruce G · Hardtner, KSS/N 12-3435N4482RBarxbar Aviation LLC · Mesa, AZBuilt 1974 · S/N 17263224N4482TIdeal Aviation LLC · Auburn, PABuilt 1972 · S/N 28-7205169N44836Monadnock Aviation Inc · Keene, NHBuilt 1977 · S/N 28-7816025N4483JHelms Tate · Lake Charles, LABuilt 1967 · S/N 28-22900N4483MLorring David W · Fairbanks, AKBuilt 1947 · S/N 12-3436N4483XBowers Gregory L · Greensboro, NCBuilt 1975 · S/N 28-7690020N4483ZWild Valley LLC · Wasilla, AKBuilt 1969 · S/N 18-8837N44847Hill David F · Pembroke, MABuilt 1977 · S/N 28-7816026N44848Flabob Airport LLC · Riverside, CABuilt 1941 · S/N 4477N4484XDelta Charlie Aviation LLC · Royal Palm Beach, FLBuilt 1975 · S/N 28R-7635056N44855Marshall Xavier T · Carson, CAS/N 28-7816028N44858Swaz Aviation LLC · Mesa, AZBuilt 1977 · S/N 28-7816032N4485ACrabb Philip E · Fairbanks, AKBuilt 1956 · S/N 18-4850N4485FSaunders Raymond C III · Albuquerque, NMBuilt 1976 · S/N 28-7790033
Back to AD 90-04-06 R1