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.

N5621XDiorio Joseph · Murrieta, CABuilt 1971 · S/N 18260796N5621ZJon Air LLC · Dover, DES/N CE-1463N56220Seashell Aviation LLC · Milton, FLS/N 28-7325591N56224Thomas Way LLC · Jackson, MIBuilt 1973 · S/N 28-7305554N56227Registration Pending · Ira, MIRegistration pendingBuilt 1973 · S/N 28-7305555N5622ECivil Air Patrol Inc · Maxwell Afb, ALBuilt 1983 · S/N 18268334N5622KAyorinde Olawale T · Upper Marlboro, MDBuilt 1973 · S/N 28-7305556N5622PBaker Franklin E · Montgomery, ILBuilt 1959 · S/N 24-691N56231Leber Oliver P · Spanish Fort, ALBuilt 1973 · S/N 28-7310173N56239Hobart Aviation Inc · Akron, OHS/N 28-7325593N5623EKd3262 LLC · Downers Grove, ILBuilt 1978 · S/N 17271905N5623GMorris Hancock Flying Club · Morris, MNBuilt 1979 · S/N 17273562N5623KLyell Danny P · Ridgeway, SCBuilt 1964 · S/N CD-748N5623UMendoza Cesar · Anthony, NMBuilt 1969 · S/N 28-26419N56241Smith Bonny L · Milan, INBuilt 1973 · S/N 28-7305558N56247Aviair Corp · Tequesta, FLBuilt 1973 · S/N 28R-7335391N5624GFoothill Aircraft Sales & Service · Upland, CABuilt 1979 · S/N 17273563N5624KWilson Robert J Jr · Gaithersburg, MDBuilt 1964 · S/N D-7382N5624PCobb Jeremiah B · Colorado Springs, COBuilt 1959 · S/N 24-693N5624QSwanson Shawn · South Beloit, ILBuilt 1965 · S/N 668N5624SKin-Air Inc · Hendersonville, TNFirst renewal noticeBuilt 1966 · S/N D-8168N56256Flying Bears Aviation LLC · Wilmington, DEBuilt 1973 · S/N 28-7305559N5625KChung Thomas · Stanwood, WABuilt 1964 · S/N D-7385N5625QFly High Aviation LLC · Margate City, NJBuilt 1965 · S/N 3011N5625USkorina Air LLC · Walla Walla, WABuilt 1969 · S/N 28-26421N56264Fingerlakes Aviation LLC · Marietta, NYBuilt 1975 · S/N 28R-7535212N5626LMw Aviators LLC · Olathe, KSBuilt 1972 · S/N AA5-0226N5626UFly Around Alaska LLC · Palmer, AKBuilt 1969 · S/N 28-26423N5626WMiller Andy · Marana, AZBuilt 1962 · S/N 28-769N56277Lightfoot John A · Hagerstown, MDBuilt 1973 · S/N 32-7300056N5627BTaylor Tona R · Graham, WABuilt 1956 · S/N 33627N5627FFolger Alfred J · Columbia, SCBuilt 1976 · S/N 28-7715144N5627KTaxman Aviation Training Inc · Port Orange, FLBuilt 1964 · S/N TC-614N5627UMcelhannon Susan L · Athens, GABuilt 1969 · S/N 28-26422N5627WSavio Stefan V · Trophy Club, TXBuilt 1962 · S/N 28-772N56280Briggs Samuel K · Portland, ORBuilt 1973 · S/N 28-7325597N56281Lewis Nathan Timothy · Hayden, IDS/N 28-7325598N56282Kowatra Anil K · Lilburn, GAS/N 28-7325601N56283Stephens Donald K · Modesto, CABuilt 1973 · S/N 28R-7335399N56286Rigoni Terry N · Prescott, AZS/N 7221CN56288Cole Douglas W · Kennewick, WAS/N 28-7325604N56289Butler Stephen P · Ossian, INBuilt 1973 · S/N 28-7305564N5628FHobbs Jason · Saint Francisville, LABuilt 1976 · S/N 28-7715145N5628JAviate 208 LLC · Oconomowoc, WIBuilt 1974 · S/N 18263476N5628LRegistered aircraftBuilt 1990 · S/N CE-1460N5628PMiller Space A · Simi Valley, CABuilt 1959 · S/N 24-698N5628SSchrier Timothy · Savage, MNBuilt 1966 · S/N TD-657N5628WB & D Aviators LLC · Bremen, INBuilt 1962 · S/N 28-773N56290Franscioni Farms Inc · Salinas, CABuilt 1978 · S/N 7220CN56291Mccall Albert B II · Lebanon, TNS/N 7223C
Back to AD 2007-04-19 R1