OpenAirDocs.org
AD 2007-04-19 R1

Registered aircraft · 108,433

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.

N24029Bindas Ronald · Georgetown, TXBuilt 1977 · S/N MB-840N2402ALaurelton Village Inc · Alamance, NCS/N TC-1931N2402PSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1956 · S/N 18-4261N2402RSmith Porter Allen · Aztec, NMBuilt 1964 · S/N 18255502N2402TMoehling Richard Lee · Cleveland, OKBuilt 1962 · S/N NAV-4-2402N2402XTeeter Ralph R · Caldwell, IDS/N 18256302N2403GZeus Air Inc · Wilmington, DEBuilt 1958 · S/N 51703N2403QSkydive Harbor Springs Inc · Charlevoix, MIBuilt 1966 · S/N 18257603N2403RDuck Dennis H · Jefferson City, TNBuilt 1964 · S/N 18255503N24041Texas Flight Training Aircraft 8 LLC · Wilmington, DEBuilt 2010 · S/N 4496290N2404CWatts Noah D · San Antonio, TXS/N 30704N2404FDe Vries James S · Pacific, MOS/N 18051604N2404PKirby Ronald S · Reno, NVBuilt 1955 · S/N 18-4266N2404QHoch Lance M · New Plymouth, IDFirst renewal noticeBuilt 1966 · S/N 18257604N2404ZSutherland Kurt Aron · Valley View, TXBuilt 1981 · S/N 18267897N24055Shipley Larry W · Corsicana, TXS/N MC-492N24057Macaluso Raymond A · Sweetwater, TNBuilt 1977 · S/N M-1937N2405GWarren Sam A Jr · Stanwood, WABuilt 1959 · S/N 51705N2405HPrevatt Stephen W DBA · Kodiak, AKBuilt 1979 · S/N 18-7909181N2405JHorne Donald Bayne Jr · Corpus Christi, TXS/N 18-7909118N2405SJohn L Lyle Aviation LLC · Ridgeland, MSBuilt 2006 · S/N 18281759N2406CRopps Spraying Service Inc · Pasco, WABuilt 1954 · S/N 30706N2406JPorter Wade R · Durham, CABuilt 1979 · S/N 18-7909119N2406QSteely John R · Anderson, SCBuilt 1966 · S/N 18257606N2406RSale Reported · Lincoln, NESale reportedBuilt 1964 · S/N 18255506N2406TThibault William K · Colonial Heights, VAS/N NAV-4-2406N2406XBrumit John E Jr · Odessa, TXBuilt 2003 · S/N 01N2407GFaull James Aldo · Boise, IDBuilt 1958 · S/N 51707N2407NPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2007 · S/N 172S10550N2408CDoughnut Wings Aviation LLC · Lewes, DEBuilt 1955 · S/N 30708N2408FDawson Brent A · Dillingham, AKS/N 18051608N2408GEl Coyote Ranch LLC · Alzada, MTBuilt 1958 · S/N 51708N2408TR E Green Inc · Three Forks, MTBuilt 1962 · S/N NAV-4-2408N2408XWyatt David · Las Vegas, NVBuilt 1965 · S/N 18256308N2409ENutac Leasing LLC · Deland, FLBuilt 2007 · S/N 172S10552N2409TGarabedian John H · Southborough, MABuilt 1962 · S/N NAV-4-2409N2409XHarrison Nicholas R · Midland, NCBuilt 1965 · S/N 18256309N2409YLow Go Flyers Inc · Jonesville, LABuilt 1955 · S/N 31967N240AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881731N240AKPhoenix Leasing LLC · Menomonee Falls, WIFirst renewal noticeBuilt 2013 · S/N 1129-2013N240ARRiddell Orin · Coronado, CABuilt 2026 · S/N LS-228N240AVPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4496650N240CTCoast Flight Training & Management Inc · San Diego, CABuilt 2006 · S/N 17281352N240DCWestbank Fishing LLC · Kiln, MSBuilt 2002 · S/N 18281099N240DGGubert David A · Saint Johns, MIBuilt 2014 · S/N 1202N240DMRussell Robert Q · Genoa City, WIBuilt 1977 · S/N 17269757N240GBSchumaker Joseph W Jr · Petersburg, MIBuilt 1966 · S/N 310K0188N240HCBlodgett James R · Walnut Creek, CABuilt 1979 · S/N TJ-221N240JAHot Wings Aviation LLC · Indianapolis, INBuilt 2020 · S/N 28020010N240KHBurns Shane H · Waxahachie, TXBuilt 2001 · S/N 0978
Back to AD 2007-04-19 R1