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.

N37RNCicero John · Concord, CABuilt 2014 · S/N 90207N37RPPearson Landon S · Madison, SDBuilt 1992 · S/N 811-6N37RRWarshauer Holdings LLC · Atlanta, GAS/N PX1520006N37RWCitabria Aces LLC · Virginia Beach, VABuilt 1981 · S/N 969N37SACampbell John R Trustee · Saint Leo, FLBuilt 1972 · S/N 34-7250046N37SDAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13250N37SEPacific Northwest Aircraft Leasing Inc · Meridian, IDBuilt 2001 · S/N 17281035N37SGGroce Steven F · Springfield, MOBuilt 2001 · S/N 6050N37SLRw Aviation LLC · Manitowish Waters, WIBuilt 1999 · S/N 2010N37TGSale Reported · Fort Payne, ALSale reported, pending cancellationBuilt 2014 · S/N 24870N37THUnlimited Boat Sales Inc · Page, AZBuilt 2005 · S/N 1655N37TRTrofimchuck Matthew P · Coal City, ILBuilt 1996 · S/N 775-96N37UJet Set Aircraft Inc · Van Nuys, CABuilt 1977 · S/N 414A0010N37VMVictory Maximus LLC · Dublin, OHBuilt 1984 · S/N 46-8508002N37WEagle Peak Links LLC · Cheyenne, WYBuilt 1970 · S/N 18260402N37WDRudy Schmitt · Brookshire, TXBuilt 1967 · S/N 28-4550N37WMSanders Wiley C Jr · Troy, ALBuilt 1951 · S/N 21690N37WRStill Flying LLC · Carlisle, PABuilt 1975 · S/N 0721N37WTFaulk County Flying Club Inc · Faulkton, SDBuilt 1978 · S/N 17271385N37WYWyo Ventures LLC · Buffalo, WYBuilt 2001 · S/N 2169N37XPLacey Scott M · Morris, ILBuilt 1976 · S/N K-037N37YRogers Jeffrey · Bend, ORBuilt 1962 · S/N CD-548N37ZAMulder Theodor Louis · Overgaard, AZS/N 377AN38000Gardner David J · Elk, WAS/N M-2297N3800DParker Bruce C · Boise, IDBuilt 1957 · S/N 34500N3800FCampbell Joseph P · Vail, AZBuilt 1977 · S/N 0768N3800PRem Real Estate Investments LLC · Longview, TXBuilt 2005 · S/N 1676N38010Bht Aero LLC · Seymour, INS/N 22644N3801BSunshine N756fc LLC · Stamford, TXBuilt 1980 · S/N CE-931N3801CDanuser Aviation LLC · Fulton, MOBuilt 1980 · S/N EA-167N3801DMann Lyle D · Summerville, ORBuilt 1957 · S/N 34501N3801PKnutson Wayne R · Thompson, NDBuilt 1955 · S/N 22-3490N3801TSeefeldt John V · Monticello, MNBuilt 1967 · S/N 28R-30115N3801WSale Reported · Silver City, IASale reportedS/N 32-729N38020Pardue Hines Aviation LLC · Lincolnton, NCBuilt 1980 · S/N TH-1208N3802DCorbitt Mindy J · Ocoee, FLBuilt 1957 · S/N 34502N3802NDiehl Donald L · Garden City, KSBuilt 1980 · S/N EA-170N3802PCassill Aircraft Leasing Inc · Cedar Rapids, IABuilt 1980 · S/N E-1782N3802RN3802r LLC · New Ringgold, PABuilt 1970 · S/N 28-5830N3802XFerri Thomas K · Hillsborough, NCBuilt 1980 · S/N CE-932N3802ZRowland Keith E · Glennallen, AKBuilt 1960 · S/N 18-7535N38032Buchanan Garrison J · Woodside, CABuilt 1951 · S/N 23453N3803DSaunders Clinton E · Belgrade, MTS/N 34503N3803ESorbi Aviation Inc · El Cajon, CABuilt 1981 · S/N ME-381N3803FPiercy Ronald S · Moses Lake, WABuilt 1977 · S/N 0771N3803MRegistered aircraftBuilt 1980 · S/N D-10357N3803QAmerican Patrols Inc · Midland, TXBuilt 1971 · S/N 17259903N3803WDelp Ryan K · Southbury, CTS/N 32-731N3803ZDeines Gerald G · Red Lodge, MTBuilt 1960 · S/N 18-7536N38040Mosier Daniel J · Tucson, AZBuilt 1980 · S/N EA-175
Back to AD 2007-04-19 R1