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.

N269NEOro LLC · Tilden, NES/N 17272505N269PBHmw LLC · La Grange, NCBuilt 1978 · S/N R18200546N269PCSch Aviation Inc Trustee · SporleBuilt 1979 · S/N 340A0785N269R219 Air LLC · South Bend, INBuilt 1986 · S/N 8608065N269RAFuller Aire Inc · Wilmington, DEBuilt 1978 · S/N TH-998N269RHUnterreiner Dean · Prince George, VABuilt 1994 · S/N 20046N269RTTodd Jon R · Georgetown, CABuilt 2010 · S/N 72891N269RVHershey Lester E · Amelia Court House, VABuilt 2007 · S/N 90246N269SFlightco Inc · Swainsboro, GABuilt 2001 · S/N 18281061N269SAAlthof Equipment Management LLC · Jupiter, FLBuilt 2011 · S/N 18282280N269SFHarvey Kandace · Snohomish, WABuilt 1979 · S/N 690795N269STSalina Tree Inc · Salina, KSBuilt 1965 · S/N 85-0363N269TCRegistration Pending · Redmond, WARegistration pending, pending cancellationBuilt 1999 · S/N S1776N269TJSenninger Thomas P · Clermont, FLBuilt 2000 · S/N S1807N269TUAero Quest LLC · Olive Branch, MSS/N ME-95N269VCRegistered aircraftBuilt 1992 · S/N S1609N269WFThomas Wilmer C · Fairbanks, AKBuilt 1999 · S/N 30007CN269WMRenninger Log Homes · Meeker, COBuilt 1959 · S/N 18-6874N269WTWillis James A · South Jordan, UTBuilt 1972 · S/N 340-0104N269YEyles Richard L · Galloway, OHBuilt 1965 · S/N 30-798N269YADavenport Ross K · Raleigh, NCBuilt 1994 · S/N RV-6-21606N26AAMustang Sally Aviation LLC · Camden, SCBuilt 2016 · S/N 172S11693N26ADTango Aviation LLC · Valrico, FLS/N 20264N26AESwallows Inc · San Jose, CABuilt 1976 · S/N 230(2106)N26AJByford Christopher H · Mc Gregor, TXBuilt 2005 · S/N 90444N26AKLousberg Daniel A · Wasilla, AKBuilt 1974 · S/N 18-7409079N26AUMaximum Entropy Inc · Wilmington, DEBuilt 1979 · S/N 282 (37-002)N26AWAntique Aircraft And Automobile LLC · Van Alstyne, TXS/N 32544N26AYR44 White LLC · Kalispell, MTBuilt 2022 · S/N 14547N26BMRegistered aircraftBuilt 1999 · S/N 18280659N26BQAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13219N26BRStender Aviation B LLC · Huntsville, ALBuilt 1983 · S/N E-2072N26BWBestul Greg · Lester Prairie, MNBuilt 1967 · S/N 30-1559N26BXPeak Performance Helicopters LLC · Dover, DEBuilt 2023 · S/N 14659N26BYSnohoacro LLC · Mukilteo, WABuilt 2004 · S/N 963-2004N26CFKustatan Leasing LLC · Nikiski, AKBuilt 1975 · S/N 20700306N26CLPuckett Lewis R · Ellijay, GABuilt 1973 · S/N CL72N26CMLaurel Highlands Aeronautical Academy · Latrobe, PABuilt 1958 · S/N TD-119N26CRSim International Inc · Fort Mill, SCBuilt 1973 · S/N 21060084N26CSJetswiss LLC · Overland Park, KSBuilt 1993 · S/N E-2814N26CUAnselmo Jeffery A · Fairfield, CABuilt 1986 · S/N U20606984N26CWBarzelatto Brett · Thornton, COS/N 17272496N26CXCiholas Philippe A · Sedgwick, KSBuilt 1970 · S/N 244949N26DASimons Thomas A · Howes, SDS/N 001N26DBDen Besten Dale L · Canton, SDBuilt 1993 · S/N 007N26DCAce Aviation LLC · Reading, VTBuilt 1965 · S/N 32-64N26DEContinental Title Trust LLC Trustee · Wichita, KSBuilt 1974 · S/N TC-1796N26DHZurinsky Richard · Port Orchard, WABuilt 1978 · S/N DH-1N26DLHayden David Bernard Trustee · Roach, MOBuilt 1973 · S/N 18502287N26DSSimorgh LLC · Omaha, NEBuilt 1979 · S/N 61P07037963337
Back to AD 2007-04-19 R1