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.

N2522XAce Handyman Services LLC · Sussex, NJS/N P206-0022N2523AChadwick Harold T · Ottsville, PABuilt 1952 · S/N 22-829N2523GDannebrog Air LLC · Grand Island, NEBuilt 1959 · S/N 51823N2523PHarris Jason C A · Unalakleet, AKS/N 22-2885N2523QLusk T Quizy · Springfield, COBuilt 1966 · S/N 18257723N2523RBergamaschi Brian A Trustee · Davis, CABuilt 1967 · S/N 18258223N2523UPro Renovations Savannah Ltd Co · Savannah, GABuilt 1979 · S/N 28-8016030N2523ZBchr Aviation LLC · Boerne, TXBuilt 1977 · S/N 337-77N2524KGanz Brian L · Carlsbad, CABuilt 1978 · S/N 18052969N2524MDd Leasing LLC · Aberdeen, IDBuilt 1946 · S/N 12-910N2524QBellamy Flying LLC · Elwood, NEBuilt 1966 · S/N 18257724N2524TMetz Daniel J · Brighton, COBuilt 1969 · S/N NAV-4-2525N2524UAir Warriors LLC · Opelika, ALBuilt 1979 · S/N 28-8016031N2524WAerowave Aviation LLC · Noblesville, INBuilt 1973 · S/N MC-196N2524ZEgan Brian M · Saint Charles, ILBuilt 1977 · S/N 338-77N2525Davis Bill M · Kent, WABuilt 1976 · S/N 28-7790180N25259Miller Eric J · Mendocino, CAS/N 982N2525GWoods Dana · Mountain View, ARBuilt 1959 · S/N 51825N2525KAvenue Enterprises Transportation LLC · Longboat Key, FLS/N 0890N2525QHohman Cory A · Lometa, TXBuilt 1966 · S/N 18257725N2525RBrandt Jimmie L · Elbert, COBuilt 1967 · S/N 18258225N2525SJbird Aviation LLC · Elizabeth City, NCBuilt 2025 · S/N 1225-2025N2525TPaliughi Ronald D · Fresno, CAS/N NAV-4-2521N2525XTolbert Mark A · Canandaigua, NYBuilt 1977 · S/N 21061803N2525YWilde Stephen · Elverta, CABuilt 1985 · S/N 28-8516075N2525ZMansfield Scott J · Wasilla, AKBuilt 1962 · S/N 185-0525N2526MTulin Donald J · Anchorage, AKS/N 12-1017N2526RTalkeetna Denali View Lodge LLC · Talkeetna, AKBuilt 1967 · S/N 18258226N2526SPlane Nutz LLC · Sugar City, IDBuilt 1979 · S/N R18201347N2526WCulling Thomas E · Venice, FLBuilt 2000 · S/N 25419N2526XBolin David A · Kenmore, WAS/N P206-0026N25278Winterton Phillip C · Tucson, AZS/N 1001N2527DSidders Michael E · Big Lake, AKS/N 20679N2527GRafter H Livestock · Rawlins, WYBuilt 1959 · S/N 51827N2527PSprenger Michael D · Juneau, AKBuilt 1955 · S/N 22-2890N2527QTwenty Inc · Wilmington, DES/N 18257727N2527UDeljanovan Trucking LLC · Roaring Branch, PABuilt 1979 · S/N 28-8090050N2528Morrison Garrett B · Lodi, CABuilt 2016 · S/N 7149N2528EMr Dent Inc · Manheim, PAS/N 869N2528RHutchens Robert L II · Mocksville, NCBuilt 1967 · S/N 18258228N2528SScola Kevin M · Marshfield, MABuilt 1979 · S/N 18-7909153N2528UPensacola Navy Flying Club · Pensacola, FLBuilt 1979 · S/N 28-8090051N2528XButcher Collin E · Freeport, TXBuilt 1964 · S/N P206-0028N252AALadson Timothy L · Savannah, GABuilt 1961 · S/N CD-330N252AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281185N252AXFrequency Change Aviation Services Inc · Nashville, TNBuilt 2004 · S/N 40.392N252CERegistration Pending · Springtown, TXRegistration pendingBuilt 2003 · S/N 4166N252CMRouse Peter L · Parkville, MOBuilt 1996 · S/N 4002N252CWNelson Shalom Z · Washington, DCBuilt 2004 · S/N 31N252DLPlac Holdings LLC · Paradise, TXBuilt 1975 · S/N 310R0242
Back to AD 2007-04-19 R1