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.

N32488Registered aircraftBuilt 1974 · S/N 28-7515168N3248DPalmer Cade E · Eagle River, AKBuilt 1955 · S/N 32046N3248LPreferred Management Corp · Shawnee, OKBuilt 1995 · S/N TH-1748N3248PAero Spectra Corp · Boulder, COS/N 23-1193N3248SHanson Glen W · Anchorage, AKBuilt 1964 · S/N 18255748N3248TBrydon Robert J · Austin, TXBuilt 1995 · S/N E-2948N3248WKeifer Ronald C · Port Orange, FLBuilt 1965 · S/N 32-66N32490Jackson Charles A · Winchester, KYBuilt 1974 · S/N 28-7515169N32492Doyle Dylan D · Cerrillos, NMBuilt 1974 · S/N 28R-7535063N3249DBielanski Allan · Larkspur, COBuilt 1995 · S/N E-2949N3249FRoberto Jeffrey M · Piscataway, NJBuilt 1967 · S/N 670042N3249JSelge Leasing Inc · Niles, MIS/N E-3349N3249UHutchison Roger R · Sioux Falls, SDBuilt 1963 · S/N 18254649N3249WMountain West Aviation LLC · Albuquerque, NMBuilt 1965 · S/N 32-67N324ALauridsen Hans O · Scottsdale, AZFirst renewal noticeS/N 9962CCN324AKKeiser John T · Santa Fe, NMBuilt 2018 · S/N CC19-0041N324BBN324bbjf Inc Owner Trustee · Wilmington, DEBuilt 1999 · S/N 647N324BHN324bh LLC · Roanoke, VABuilt 2025 · S/N E-4162N324CFerris Ryan P · Rochester, NYBuilt 1999 · S/N 374-320-129N324CADrakes Landing Inc · Archibald, LABuilt 2023 · S/N 14605N324CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 172S12135N324CSBrush Country Helicopters LLC · Laredo, TXBuilt 2013 · S/N 2321N324DBush David M · Englewood, COBuilt 1965 · S/N D-8016N324DBDaugherty Warren F Jr · Jonestown, PABuilt 1956 · S/N 324N324DHWood Thomas E · Sherrills Ford, NCBuilt 1979 · S/N AA5B1259N324DNFluckey Craig · Plattsmouth, NEBuilt 2003 · S/N 80820-001N324EAWaytack LLC · Bryant, ARBuilt 2015 · S/N TH-2452N324GIsle Air LLC · Danbury, CTBuilt 1995 · S/N 3246003N324GT324 Aviation LLC · Cavour, SDBuilt 1979 · S/N EA-38N324MARollings Hills Aviation Inc · Pelham, GABuilt 2002 · S/N 1330-2002N324PTPlanedocs LLC · Spearfish, SDBuilt 2007 · S/N 40081N324QLove Charles Keith · Asheville, NCBuilt 1999 · S/N TH-1909N324RHPhillips William L Trustee · E Hampton, MABuilt 1979 · S/N 18267211N324RJSchelhorn Timothy J · Nampa, IDS/N 18254601N324RPClear For Take Off LLC · Burlingame, CABuilt 2004 · S/N 18281422N324RVAmsa Jet Crew Solutions LLC · Windermere, FLFirst renewal noticeBuilt 1998 · S/N 24895N324SVDavis Kyle R · Colleyville, TXBuilt 1980 · S/N R18201609N324TAIslander Holdings Ltd · Fort Lauderdale, FLBuilt 1980 · S/N 892N324TSDes Moines Flying Club LLC · Indianola, IABuilt 1966 · S/N 32-841N324WCSebastian Charles J · Baytown, TXBuilt 2020 · S/N 131-255B/256B-1379N324XFontenot Ira Dean · Collierville, TNBuilt 1975 · S/N 300N324YCesscon LLC · Yalesville, CTBuilt 1976 · S/N 18264524N324ZHannon Jim H · Cumming, GABuilt 1960 · S/N D-6478N32500Fairfield Flying Service Inc · Fairfield, IAS/N 28-7525076N32501Meives Mark J · Barneveld, WIS/N 28-7515171N32505N83at LLC · Dover, DEBuilt 1974 · S/N 28-7505065N32506Schuhler Louis A · Plainfield, ILBuilt 1974 · S/N 28-7505066N3250FMantissa Corporation · Charlotte, NCBuilt 1967 · S/N 670043N3250JHigh Mesa Aviation LLC · Naturita, COBuilt 1966 · S/N 15065950N3250U50 Uniform LLC · Traverse City, MIBuilt 1963 · S/N 18254650
Back to AD 2007-04-19 R1