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.

N46470Registration Pending · St Charles, ILRegistration pendingBuilt 1968 · S/N 17257291N4647AAuch Leo R · Scio, ORBuilt 1956 · S/N 32244N4647QCowles Charles Orville · Mesa, AZS/N 71576N4647SJnjz Enterprises LLC · The Woodlands, TXBuilt 1975 · S/N TC-1910N46484Campisteguy Alexander J · Renton, WABuilt 1968 · S/N 17257298N46486Calimesa LLC · North Las Vegas, NVBuilt 1968 · S/N 17257300N4648ATimms Chet D · Central City, IABuilt 1983 · S/N P21000812N4648ERandall John Kelly · Fremont, OHBuilt 1982 · S/N 18268254N4648FSimmons Daniel A · Huntsville, ALBuilt 1966 · S/N P206-0248N4648JTutt Bryan · Louisville, KYS/N 28R-30542N4648MKaye Mykle · Wailuku, HIBuilt 1949 · S/N 14-495N4648SKoehn Danny · Montezuma, KSBuilt 1975 · S/N E-767N46493Brown Michael F · Richford, NYBuilt 1974 · S/N 17264186N46495Hanna Douglas L · Winchester, KYBuilt 1968 · S/N 17257306N46497Tones Trucking Inc · Cassopolis, MIBuilt 1968 · S/N 17257307N4649BNicholson Stephen G · Bayfield, COBuilt 1955 · S/N 31547N4649EStanberry Carl W · Anchorage, AKS/N 18503830N4649QSkyhawk Services LLC · Lake Wales, FLBuilt 1973 · S/N 17261735N4649RHartley Zachary K · Dublin, GABuilt 1966 · S/N 28-21404N4649SBrigger LLC · Wilmington, DEBuilt 1979 · S/N R18201366N4649TNew York Aircam Corp · Woodbury, NYBuilt 1981 · S/N R18201724N4649UMy Holdings Inc · Anchorage, AKBuilt 1979 · S/N U20605028N464CMUniversity Of Central Missouri · Warrensburg, MOBuilt 2000 · S/N 17280856N464CSBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 18283164N464CWSchilthelm Mark W · Hudson, OHBuilt 2023 · S/N 001N464DBCloud James G · Camden, MEBuilt 1973 · S/N 17262328N464DGLyon Garth M · Blackfoot, IDBuilt 2018 · S/N 17N464DMCoco Adam J · Quincy, MIBuilt 2002 · S/N 60329N464EABaron Four LLC · Virginia Beach, VABuilt 2012 · S/N TH-2349N464EHMurphy Dean J · Caledonia, ILBuilt 2012 · S/N 22705N464EMAdams Michael A · Auburn, WABuilt 1993 · S/N RV4AC92MEN464ERMustang Sally Aviation LLC · Camden, SCBuilt 2015 · S/N 172S11598N464FVan Bortel Aircraft Inc · Arlington, TXBuilt 2019 · S/N 18283092N464FAStratus Rr LLC · New Castle, DEBuilt 2022 · S/N 28020064N464GSHooper Mark · Elko, NVBuilt 1978 · S/N U20604744N464HExecutive Flight Training LLC · Beaufort, SCBuilt 2020 · S/N 18283120N464HSMcwaters Herbert L · Scottsdale, AZBuilt 2004 · S/N 25688N464JBHhi Aviation Inc · Newark, DEBuilt 1999 · S/N 4636199N464JSGrover David · Friendswood, TXBuilt 2004 · S/N 002N464JWWatts John C · Matthews, NCBuilt 2023 · S/N 1219N464KKing Aaron M · Knoxville, TNBuilt 1997 · S/N 18280039N464LC P Holdings LLC · Watertown, SDBuilt 2018 · S/N 18283060N464MMeyer Brent · San Antonio, TXBuilt 2002 · S/N 0221N464MASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2000 · S/N 18280822N464MSSchulze Michael F · Lees Summit, MOBuilt 2004 · S/N 1N464NDUniversity Of North Dakota · Grand Forks, NDBuilt 2026 · S/N 28010018N464PGoodgame Richard C · Fort Myers, FLBuilt 1966 · S/N D-8372N464PCJordan Thomas Harvey III · Jasper, GABuilt 2004 · S/N 1208N464RWilson Aaron I · Fairmont, WVS/N 18260464N464RB75s Leasing LLC · Greenwood Village, COBuilt 1962 · S/N TD-518
Back to AD 2007-04-19 R1