OpenAirDocs.org
AD 2007-04-19 R1

Registered aircraft · 108,428

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.

N1167Miller Timothy · Norfolk, NEBuilt 1971 · S/N 178N11673Clobes Warren J · Evansville, WIBuilt 1972 · S/N 356-72N11676Stone Air LLC · Carrollton, GABuilt 1972 · S/N 236-72N11677Irby Darrell · Keller, TXBuilt 1972 · S/N 306-72N11679King Nathan A · Dunkirk, MDBuilt 1972 · S/N 307-72N1167PCascadia Air Ventures Inc · Winlock, WABuilt 1955 · S/N 23-181N1167XHoover Adam A · Sugarloaf, PABuilt 1975 · S/N 28-7525295N11680Adams Jonathan · Columbia, MOBuilt 1972 · S/N 21-72N11681Amelia Reid Aviation LLC · San Jose, CABuilt 1972 · S/N 308-72N11682Jahawk Leasing LLC · Sugar Grove, ILBuilt 2006 · S/N 172S10365N11684Pepper Richard V · Henderson, TXBuilt 1972 · S/N 309-72N11686Hopewell Jeffrey D · Temple, TXS/N 310-72N11687Young William A · Delta Junction, AKBuilt 1972 · S/N 313-72N1168LDepaul Thomas J · Juneau, AKBuilt 1966 · S/N 330N1168PLangford Michael J · Middletown, MDS/N 3703N1168TKnight Oil Resources Inc · New Orleans, LABuilt 1975 · S/N TE-1045N1168XJz Air LLC · Brooklyn, NYBuilt 1975 · S/N 28-7505219N11690Evers William J · Sussex, WIBuilt 1972 · S/N 355-72N1169AK-Air Service LLC · Gakona, AKBuilt 1951 · S/N 18-767N1169HSwihart Matthew Allen · San Marcos, TXBuilt 1975 · S/N AA5B-0063N1169QRohde Allen G · Eagle River, AKBuilt 1977 · S/N 18503466N1169RClayton Alfred T Jr · Anchorage, AKBuilt 2007 · S/N 004N1169TMorin Daniel P · New Harbor, MEBuilt 1975 · S/N D-9770N116ABHaller Phillip · Peoria, AZBuilt 1973 · S/N TE-899N116AHRegistered aircraftBuilt 1981 · S/N 18267966N116AJJewett Chris E · Lexington, SCBuilt 2004 · S/N DC03N116AKLucas Kelly W · Wasilla, AKBuilt 1965 · S/N 18051469N116ARLower Timothy C · Biglerville, PABuilt 1997 · S/N 24850N116AVValleortiz Hector J · Laurel Hill, NCBuilt 1984 · S/N 28-8416094N116BBretana Charles Jr · Prescott, AZS/N E006N116BDTxbd Investments LLC · Addison, TXBuilt 2002 · S/N E-3454N116BGGood Bill T · Temecula, CABuilt 1955 · S/N 35116N116BKDacy Roy W · Rockport, TXS/N 32-782N116BWButler Ross W · Jackson, CABuilt 2001 · S/N 24986N116CCCrawford E Clarke · Flagstaff, AZBuilt 1992 · S/N 824N116CPCivil Air Patrol · Maxwell Afb, ALBuilt 2017 · S/N 18283012N116CRConti Christine M · Plantation, FLBuilt 1976 · S/N 17266985N116CWJazun Carlos Walter · Parker, COBuilt 2015 · S/N 0073385N116DRegistration Pending · Reese, MIRegistration pendingBuilt 2022 · S/N 18283203N116DHHoover David · Foster City, CAFirst renewal noticeBuilt 1990 · S/N 0001N116DPPaup Dennis C · Carroll, IABuilt 2006 · S/N 70194N116DWWalters Douglas B · Templeton, CABuilt 2020 · S/N 21807N116EALewistown Aviation Inc · Lewistown, PABuilt 1979 · S/N 340A0750N116ESOlson Edward H · Elizabeth, COBuilt 2021 · S/N 5N116FLMerdes Gordon B · Corpus Christi, TXBuilt 1974 · S/N 18-7509029N116FPRandall David J · Balsam Lake, WIBuilt 1978 · S/N 17271241N116GRegistration Pending · Sheridan, WYRegistration pendingBuilt 1995 · S/N 23019CN116GSTharp Thomas J · Nampa, IDBuilt 2001 · S/N 1298009N116HRegistration Pending · Kalispell, MTRegistration pendingBuilt 1964 · S/N TC-812N116HRRedpaw Aviation Ltd · Upper Arlington, OHBuilt 1986 · S/N 18268579
Back to AD 2007-04-19 R1