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.

N3284WLower James A · Greenville, MIBuilt 1965 · S/N 32-115N3284YMonnin Cass C · East Wenatchee, WAS/N 18254284N3285FAir Mods And Repair Inc · Robbinsville, NJS/N 670378N3285PLsop Rentals Premier Asset Management LLC · Gowanda, NYBuilt 1957 · S/N 23-1233N3285SCastro Manny H · Tucson, AZBuilt 1964 · S/N 18255785N32860Schroeder Scott · Decatur, TNS/N 28-7505099N32861New Hope Equipment Sales Inc · Ardmore, OKBuilt 1974 · S/N 28R-7535096N32865Minor Larry B · Glasgow, KYBuilt 1974 · S/N 28-7515265N32868Brolan Aviation LLC · Kansas City, MOBuilt 1974 · S/N 28-7515266N32870Pineland Flying LLC · Valdosta, GABuilt 1974 · S/N 28R-7535097N32871Luckie Deborah K · Kingman, AZS/N 28-7510032N32874Strawberry Aviation Inc · Watsonville, CABuilt 1974 · S/N 28-7525125N32876J-Mac Aviation Services LLC · Andalusia, ALBuilt 1974 · S/N 28-7515267N32878Hewett David R · Supply, NCBuilt 1974 · S/N 28-7515268N3287EOff Course Aero Ventures LLC · Mechanicsville, VABuilt 1978 · S/N 17271492N3287FSchaumberg John · Lebanon, INS/N 670380N3287QJase Aircraft Leasing LLC · Lenexa, KSBuilt 1977 · S/N 28-7725222N3287RWright Maurice · Las Vegas, NVBuilt 1970 · S/N 28R-31262N3288Mewmew Investment II LLC · Palo Alto, CABuilt 2020 · S/N 172S12430N32888Flying Wings Inc · Wilmington, DEBuilt 1974 · S/N 28-7515270N3288DSmith James O · Montgomery, TXS/N 32086N3288FFlightbyte LLC · Wilmington, DEBuilt 1967 · S/N 670381N3288MClute Kenneth N · Las Vegas, NVBuilt 1980 · S/N 310R1895N3288SEpple William E · Roggen, COBuilt 1964 · S/N 18255788N3288UVetch Rod F · Ranchester, WYBuilt 1963 · S/N 18254688N3288ZOney John M · Anchorage, AKBuilt 1959 · S/N 18-7218N32898Spitaleri Robert F · Winter Haven, FLS/N 28-7525126N3289AKennedy Kelly · Wheatland, WYBuilt 1953 · S/N 25933N3289FRubiales Mauricio A Jr · San Diego, CABuilt 1967 · S/N 670382N3289QTrident Aircraft Leasing LLC · Easton, MDBuilt 1977 · S/N 28-7716146N3289SDouble Lazy H LLC · Delta, COBuilt 1964 · S/N 18255789N3289URutenbeck Terry L · Wiggins, COBuilt 1963 · S/N 18254689N3289WShandon Aviation LLC · Lewes, DES/N 32-122N3289YHasselbring Ted S · Nashville, TNBuilt 1962 · S/N 18254289N328BNothing Wasted LLC · Bunker Hill, INBuilt 1966 · S/N D-8307N328CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 18283309N328CCUS Dept Of The Interior · Boise, IDBuilt 2012 · S/N CC18-0058N328CTRegistration Pending · Middleton, NHRegistration pendingBuilt 2003 · S/N 432N328DDLandsburg Custom Services LLC · Sandusky, MIBuilt 1973 · S/N 17262401N328DHBrown Kevin E · Rosamond, CABuilt 2004 · S/N BV001N328ESisson J P · Litchfield, ILBuilt 2004 · S/N 20762N328EMConcierge Diamonds Inc · Los Angeles, CABuilt 1985 · S/N 46-8508087N328FAAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13220N328GArcher Aero LLC · Wilmington, DEBuilt 2019 · S/N 2881115N328HRShuster David · Fredericksburg, VABuilt 1979 · S/N D-10269N328JMGrand Aviation Inc · Grove, OKS/N 2082N328JWL & R Cirrus Inc · Portage, PABuilt 2002 · S/N 0225N328LDuffield Brian · Eastvale, CABuilt 1973 · S/N 18262043N328MN328m LLC · Marion, INBuilt 2001 · S/N TH-1992N328MBN328mb LLC · Old Bridge, NJBuilt 2004 · S/N 0867
Back to AD 2007-04-19 R1