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.

N5358UMadson Chris · King City, CABuilt 1984 · S/N 21064877N5359APalo Duro Aircraft Services Lc · Mckinney, TXBuilt 1979 · S/N 21063388N5359BLebbon Lee T · Annville, PAS/N 33359N5359ESchaperkotter Harold M Jr · Nashville, TNBuilt 1959 · S/N D-5875N5359FWashington Fliers Club Inc · Washington, IABuilt 1976 · S/N 28-7790098N5359KAbove And Beyond Aviation LLC · Austin, TXBuilt 2003 · S/N 172S9447N5359LFirst Flight Corp · San Diego, CABuilt 1968 · S/N 28-4663N5359PPanhandle Groundwater Conservation District · White Deer, TXBuilt 1958 · S/N 24-408N5359SRegistered aircraftBuilt 1980 · S/N R18201554N535AZBuzz Rickson Aviation LLC · Wilmington, DEBuilt 1997 · S/N 1AP002-02N535BEValiair Lc Trustee · Casper, WYBuilt 1970 · S/N D-9170N535CCrystal John · Las Vegas, NVBuilt 1998 · S/N 29-0146N535CRScs Assets LLC · Ponce, PRBuilt 1979 · S/N 414A0244N535DCCamber Air LLC · Santa Ana, CABuilt 1980 · S/N 18267681N535EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2024 · S/N 172S13168N535HFPars Avn Corp · Wilmington, DEBuilt 2000 · S/N 17280926N535KSKent State University · Stow, OHBuilt 2013 · S/N 172S11321N535LEAirman Helicopter Inc · Fort Lauderdale, FLBuilt 2026 · S/N 2857N535LMMillcopter LLC · Wahpeton, NDBuilt 2007 · S/N 1790N535MESky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N P21000345N535PTaylor Jim A · Kernersville, NCBuilt 1966 · S/N D-8119N535PGSs Aviation LLC · Westlake, LABuilt 2005 · S/N 1293N535QGeaux Fly LLC · Bossier City, LABuilt 1968 · S/N TE-609N535RFlight Training Pro LLC · Nashville, TNBuilt 2005 · S/N 29-0381N535RARich Aviation Services LLC · Fort Worth, TXBuilt 1968 · S/N TC-1126N535RHHarkness Richard · Hanahan, SCBuilt 2017 · S/N 7087N535RTN535rt LLC · Provo, UTS/N 0407N535SCardoza Real Estate Inc · Eagle, IDBuilt 2001 · S/N 0014N535SBSpeedy Bonanza LLC · Waitsfield, VTBuilt 1964 · S/N D7485N535TAns Construction LLC · Swedesboro, NJBuilt 1961 · S/N CD-322N535TKSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 14025CN535TWJohnson William · New Wilmington, PABuilt 1973 · S/N 28R-7335381N535TXCoolidge Robert P · Rio Vista, TXBuilt 1960 · S/N D-6396N535VBSchellenger Jonathan H · Port Saint Lucie, FLBuilt 1975 · S/N D-9742N535WNichols David A · Oneonta, ALBuilt 1965 · S/N D-7897N535WCMetro West Ambulance · Hillsboro, ORBuilt 1981 · S/N 18504195N535WPMcmillin Robert E · Wampum, PABuilt 2007 · S/N 90825N53600Kdrd Holdings LLC · Texas City, TXS/N 17272544N53603Wings Over Texas Holdings LLC · Denton, TXBuilt 1981 · S/N 17274786N5360EStrahm Ralph E · Holtville, CABuilt 1959 · S/N D-5848N5360JFly Montana LLC · Miles City, MTBuilt 1980 · S/N 17273763N5360KN5360k LLC · Lebanon, MOBuilt 2002 · S/N 3246207N5360LKitzmiller Peter Charles · Seattle, WAS/N 28-4664N5360PN5360p LLC · Blacklick, OHBuilt 1958 · S/N 24-409N5360WShaffer Thomas D · Round Rock, TXS/N 28-425N53611Aero Mobil Inc · Wilmington, DEBuilt 1981 · S/N 17274787N53614Orange County Flight Center Inc · Santa Ana, CABuilt 2003 · S/N 172S9413N5361BSkydive Ricks LLC · Petersburg, OHBuilt 1956 · S/N 33361N5361DPannone Steven R · Palmer, AKBuilt 1958 · S/N 50259N5361KLong Island Soaring Association · Shirley, NYBuilt 1980 · S/N 17274080
Back to AD 2007-04-19 R1