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.

N4569SMiles Lawrence W Jr · Sacramento, CABuilt 1975 · S/N E-745N4569XSequoias David O · Waxhaw, NCBuilt 1975 · S/N 287625057N4569YDebilt Bruce A · Berthold, NDBuilt 1967 · S/N 25-4232N456AMKrause Kade G · Jackson, MTBuilt 1998 · S/N 1412N456ASGutman Daniel W · North Andover, MABuilt 2004 · S/N 40.456N456ATBonanza Aircraft Lc · Steamboat Springs, COS/N EA-252N456AZOne Point 7 Air LLC · Ravensdale, WAS/N 13794N456BHCastleton Real Estate & Developlment Inc · El Monte, CAS/N R18201482N456BRPressurized LLC · Sequim, WAFirst renewal noticeBuilt 1981 · S/N P21000717N456BTHatfield Timothy E · Parowan, UTBuilt 2013 · S/N 4712N456BWCustom Wholesale Supply Co Inc · Odessa, TXBuilt 1975 · S/N 20700298N456CASlake James T · Portage, INBuilt 1966 · S/N 28-10733N456CBCollins Bruce H · Caldwell, TXBuilt 1968 · S/N 17257257N456CCYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 2881506N456CSZhang Li · Palo Alto, CABuilt 2016 · S/N 18282451N456CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282445N456CWSale Reported · Fort Denaud, FLSale reportedBuilt 1982 · S/N 21064676N456DSlesser Carl J · Crestwood, KYBuilt 1993 · S/N 21569N456DCCatalpa Holdings LLC · Las Vegas, NVBuilt 2005 · S/N 1525N456DHWilliams Metal And Machinery LLC · Irvington, ALS/N 21058042N456DJSingle Raj Pa Inc · Seattle, WABuilt 1982 · S/N R18201888N456DLGt Aviation LLC · Mountain Home, ARBuilt 1972 · S/N TC-1461N456DMHnw Aviation LLC · Melbourne, ARBuilt 1978 · S/N E-1378N456DPBorder Zachary J · Molalla, ORBuilt 1991 · S/N 365N456DWJstream Lc · Sheridan, WYS/N 21040N456DXAviolease LLC · Vancouver, WABuilt 2005 · S/N 172S9871N456EMMiller William E · Goldsboro, NCBuilt 2013 · S/N 91893N456GGCoward Lawrence Jayson · Paris, TXBuilt 2004 · S/N 0896N456HWestwind Inc · Marina, CABuilt 1951 · S/N NAV-4-2228-BN456HLCrawford Clark W Trustee · La Quinta, CABuilt 2013 · S/N 72282N456HUCornelius Wayne · Mount Arlington, NJBuilt 1998 · S/N 1436N456JDLehner Jeffrey K Trustee · The Woodlands, TXBuilt 2004 · S/N 80485N456JGGronemeyer Jens · Deland, FLS/N 18264380N456JJRichardson Ruben R · Yuma, COBuilt 2019 · S/N 14314N456JMLandmark Aviation Services LLC · Sarasota, FLBuilt 1974 · S/N 340-0535N456KPNorthern Arizona Renal Aviation LLC · Flagstaff, AZBuilt 1991 · S/N CE-1597N456KWQualitair LLC Trustee · MichelstadtBuilt 1982 · S/N TJ-427N456LLemma Joseph M · Parker, COBuilt 1962 · S/N 28-863N456MDMyres Mark D · Freeland, WABuilt 1996 · S/N 20107N456MHQuality Coal LLC · Mount Sterling, KYBuilt 2011 · S/N 13207N456MLLangbehn Land & Cattle Co Inc · Wolsey, SDBuilt 2016 · S/N 13970N456PAH&H Helicopter LLC · Sauget, ILFirst renewal noticeBuilt 2019 · S/N 1242N456PBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1997 · S/N 400-97N456PCMendelson Mark L · Owego, NYBuilt 2018 · S/N 25787N456PMBerry Michael G · Hot Springs, ARBuilt 1966 · S/N 28-22354N456PSGaston Trevino Jr · Brownsville, TXBuilt 2004 · S/N 29-0335N456RBSammons Michael A · Lubbock, TXS/N 654N456RDWings To Roam LLC · Bend, ORBuilt 2009 · S/N 72631N456RHMalik Todd S · Matthews, NCBuilt 1979 · S/N AA5B1252N456RJGraae Michael Horace · Los Angeles, CABuilt 1995 · S/N 21701
Back to AD 2007-04-19 R1