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.

N115UVUtah Valley University · Orem, UTBuilt 2020 · S/N 40.1222N115VSSei Vincent J · Albuquerque, NMBuilt 2005 · S/N 115N115WCDougherty Caroline J · Bethel, PABuilt 1993 · S/N 1001N115WDWalton Paul L · Indianapolis, INBuilt 1972 · S/N TE-863N115WSJorgenson Brian K · Sandpoint, IDBuilt 1990 · S/N 2185N115WTWray Robert J · Abilene, TXBuilt 2008 · S/N 1144N115XTStaley Ronald L · Lebanon, ORBuilt 2002 · S/N 2216N115YPIaba LLC · Norfolk, VAS/N L2K 143N11600Nolan James B · Chandler, AZBuilt 1975 · S/N 17702354N11608Aircraft Trade Group LLC · Scandia, MNBuilt 1975 · S/N 17702357N1160JSchreiber William E II · Edgar, WIBuilt 1973 · S/N 125N1160UPiper Aircraft Inc · Vero Beach, FLBuilt 2025 · S/N 28020245N1160XWagner Robert J · Dubuque, IABuilt 1975 · S/N 28R-7535261N11614Lewis University · Romeoville, ILBuilt 2006 · S/N 172S10360N1161ALindemann Robin · Anchorage, AKS/N 18-2691N1161HEngert Armin L · Kahului, HIBuilt 1976 · S/N 28-7715312N1161JMnd Services LLC · Joliet, ILBuilt 1974 · S/N 161N1161XBarnett Donald R · Atoka, TNBuilt 1975 · S/N 32-7500040N11625Oil Region Aviators LLC · Titusville, PABuilt 1975 · S/N 17702360N11626Frantz Ellen C · Abbeville, GABuilt 1974 · S/N 15075580N1162CReemts Randy G · Alexandria, MNBuilt 1977 · S/N 17702678N1162UHamel Raymond F Jr · Wellesley, MABuilt 2007 · S/N 18281984N1163EKnik Flying Club LLC · Anchorage, AKS/N 987-77N1163FMid-Tenn Aero Club Inc · Franklin, TNBuilt 1979 · S/N 17272962N1163JBottom Line Aviation LLC · Scranton, NDS/N 163N1163TIrish Aviation Inc · Orlando, FLBuilt 1975 · S/N TE-1033N1163XPerry Curtis · Klamath Falls, ORS/N 28-7515396N11643Henderson George L · Fresno, CABuilt 1975 · S/N 549-75N11645Tango Bravo Air LLC · Nederland, COBuilt 1972 · S/N 344-72N11646Hough Howard A · Paris, TNBuilt 1972 · S/N 311-72N11647Ronsman Harry · Talkeetna, AKBuilt 1972 · S/N 345-72N1164JTyson Bradley · Sherrills Ford, NCBuilt 2023 · S/N 18283240N1164WBeaver Brook Aviation LLC · Scotia, NYBuilt 1967 · S/N TE-400N1164XRegistered aircraftBuilt 1975 · S/N 28R-7535263N11650Dupuis Charles Jr · Breaux Bridge, LABuilt 1972 · S/N 839-72N11657Morgan Jacob R · Salem, INBuilt 1972 · S/N 347-72N11658Lorenz William D · Benson, MNBuilt 1972 · S/N 234-72N11659Villa Holdings LLC · Commerce, CABuilt 1972 · S/N 304-72N1165MArsene Eddy R · Lynnwood, WAS/N 18264237N1165TFlying J Partners Asset Management LLC · Casper, WYBuilt 1975 · S/N D-9754N1165UWings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17266872N1165ZRegistration Pending · Las Cruces, NMRegistration pendingBuilt 1965 · S/N 1555-198N11660Gottschalk Brian D · Moscow, IDS/N 305-72N11668Cummings Arthur J · Delta Junction, AKS/N 349-72N11669Cummings Arthur · Delta Junction, AKBuilt 1963 · S/N 185-0493N1166ELake Jeffrey W · Steamboat Springs, COBuilt 1977 · S/N 251-77N1166LNovack Edward A · Cairo, NYBuilt 1965 · S/N 328N1166MWarren Gregory C · Redmond, ORBuilt 1975 · S/N 18264238N1166PDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1955 · S/N 23-180N1166WFlight Operations Aircraft LLC · Wilmington, DEBuilt 2006 · S/N 172S10363
Back to AD 2007-04-19 R1