AD 2007-04-19 R1

Registered aircraft · 108,434

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:2007-04-19-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:2007-04-19-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.

N4480JGonzalez Guadalupe G · Atwater, CABuilt 1967 · S/N 28-22896N4480RSoutheastern 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-7235067N44817Tokach Nicholas J · Hinckley, OHBuilt 1974 · S/N 28-7525009N4481GRotor Leasing LLC · Indianapolis, INBuilt 2026 · S/N 14981N4481JMusser Fred R · Severna Park, MDFirst renewal noticeBuilt 1967 · S/N 28-22898N4481SAc Aviation LLC · Searcy, ARBuilt 1975 · S/N TC-1881N4481TValdes 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-7816022N4482EStaton Stephen D · Soldotna, AKBuilt 1981 · S/N 18-8109025N4482GRotor Leasing LLC · Indianapolis, INBuilt 2026 · S/N 14982N4482JWebe Properties LLC · Toledo, OHBuilt 1967 · S/N 28-22899N4482RBarxbar Aviation LLC · Mesa, AZBuilt 1974 · S/N 17263224N4482TIdeal Aviation LLC · Auburn, PABuilt 1972 · S/N 28-7205169N4482WWheels In The Well LLC · Jonesboro, ARBuilt 2000 · S/N TH-1964N4482YMiller Andy D · Marana, AZS/N 25-4140N44836Monadnock Aviation Inc · Keene, NHBuilt 1977 · S/N 28-7816025N4483CRich Aden Gene · Sequim, WABuilt 1959 · S/N 24-1257N4483JHelms Tate · Lake Charles, LABuilt 1967 · S/N 28-22900N4483RRuf Timothy · Anchorage, AKBuilt 1976 · S/N 18502969N4483XBowers 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-7816026N4484WRegistered aircraftBuilt 1974 · S/N D-9581N4484XDelta Charlie Aviation LLC · Royal Palm Beach, FLBuilt 1975 · S/N 28R-7635056N4484YMasterwings LLC · Princeton, KYBuilt 1966 · S/N 25-4144N44855Marshall 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-7790033N4485HFrancesco Grasso · Lutherville, MDBuilt 1978 · S/N 24-0746N4485SDickerson Stephen Sr · Frisco, TXBuilt 1975 · S/N D-9785N4485TKreigh Kevin M · Auburn, INBuilt 1972 · S/N 28-7225161N44863Jg Aviation LLC · Indianapolis, INBuilt 1977 · S/N 32R-7780544N4486AAerro LLC · Argyle, TXBuilt 1970 · S/N TE-808N4486FRegistration Pending · Hague, VARegistration pendingBuilt 1976 · S/N 28R-7635411N4486HJennings Sabina · Carson, CABuilt 1978 · S/N 24-0747N4486JHess Garrett J · Fullerton, CABuilt 1967 · S/N 28-22904N4486RAurora Aviation Lc · Pierce City, MOBuilt 1974 · S/N 17263228N4486SPopadich Nicholas · Monroe, MIBuilt 1975 · S/N D-9788N4486WReynolds Eric Eugene · Weatherford, TXBuilt 1969 · S/N D-9070N4486YQuality Aviation Inc · Marana, AZBuilt 1966 · S/N 25-4147N44872Allmond Aviation LLC · Peoria, ILBuilt 1977 · S/N 28-7816033N4487KMid Atlantic Air Museum · Reading, PABuilt 1948 · S/N NAV-4-1487N4487PAccelerated Aviation Instruction LLC · Owatonna, MNBuilt 1962 · S/N 23-2009N4487SHanson Raymond H · Thousand Oaks, CABuilt 1975 · S/N E-708N4487YWitthuhn Johnie B · Callaway, NEBuilt 1966 · S/N 25-4150
Back to AD 2007-04-19 R1