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.

N23GDPhoenix Composite Solutions LLC · Oscoda, MIBuilt 1978 · S/N 17270903N23GFShenk David K · Longmont, COBuilt 1998 · S/N 23184N23GJIbis Air LLC · Lenoir City, TNS/N 1866N23GLAtlantic Assets Holding LLC · Dover, DEBuilt 1980 · S/N 414A0509N23GNMidwest General And Mechanical Contractors Inc · Highland, WIS/N 23-1415N23GVCongressional Flying Club · Gaithersburg, MDBuilt 1974 · S/N 17264594N23HARegistration Pending · Garden City, MIRegistration pendingS/N 1148N23HBHotel Bravo Aviation LLC · Houston, TXFirst renewal noticeBuilt 1977 · S/N 21062050N23HESoaring Eagle Horizons LLC · Scottsdale, AZBuilt 2010 · S/N E-3940N23HGWilkinson Dan · Morgan, UTBuilt 1994 · S/N 1269N23HHGo Fly Maui LLC · Paia, HIBuilt 2017 · S/N 14155N23HKMaine Instrument Flight · Augusta, MEBuilt 1977 · S/N M-1911N23HLWood Douglas K · Martinez, CABuilt 1979 · S/N E-1509N23JDraco Flight School Inc · Chino, CAS/N 310I0108N23JGPatriot Marine LLC · New Haven, CTBuilt 1976 · S/N JRG001N23JKDay William Bruce · Roach, MOBuilt 1975 · S/N AA5B-0022N23JMMaynard Jared M · Kendall, NYBuilt 1998 · S/N 1244-98N23JPWaller Hugh · Seaside Park, NJS/N STS2N23JTWhitman Michael V · Guys Mills, PABuilt 1972 · S/N 28-7325192N23JVScott Kelly A · Reno, NVBuilt 1984 · S/N 754-2544N23KAAshby Clark S · Pleasant Grove, UTBuilt 1991 · S/N 3121N23KBRegistered aircraftBuilt 1985 · S/N P21000845N23KRUniversity Of Central Missouri · Warrensburg, MOBuilt 2023 · S/N 172S12952N23LDVongottsegen Erik · Sweet Home, ORBuilt 1998 · S/N OJALA-0001N23LGGist Thomas Hottel III · Little Rock, ARBuilt 1959 · S/N 24-832N23LHHill Lawrence E · Marion, MTBuilt 1974 · S/N 18502433N23LKHernandez Byron Jr · Buffalo, NYBuilt 1976 · S/N 185-03085N23LNJw Air LLC · Suffolk, VABuilt 1975 · S/N 550-75N23LWGateway Air Center Inc · Merced, CABuilt 2005 · S/N 1450N23MAOglesby John · Graford, TXBuilt 2015 · S/N 3228N23MFTriay Services LLC · Metairie, LABuilt 1974 · S/N TC-1684N23MGNewhall William G · Longmont, COBuilt 1971 · S/N 39-28N23MSScalera Michael R · Apache Junction, AZS/N 1N23MTRutan Aircraft Flying Experience · Waller, TXBuilt 1985 · S/N 955N23MXExtremeaerosports.Com LLC · Corvallis, ORBuilt 2013 · S/N 6N23MZGulfstream Media LLC · Daytona Beach, FLBuilt 1972 · S/N 17260459N23NFLyman Scott · Kimberly, IDS/N 3233N23NPAia Foxtrot LLC · Henderson, NVBuilt 2023 · S/N 172S12984N23NVAvk Air LLC · Harvest, ALBuilt 1977 · S/N 32R7780373N23NYKahn Mitch · Scarsdale, NYBuilt 1987 · S/N E-2359N23PNovabox LLC · Wilmington, DEBuilt 1998 · S/N 3128N23PDHigh Sierra Flying LLC · Incline Village, NVBuilt 1976 · S/N MC-408N23PFBagge Tom · Monticello, IABuilt 1968 · S/N 310P0044N23PRTaunton Skies LLC · Dover, DEBuilt 2008 · S/N TH-2243N23PWHoag Arthur S · Windsor, COBuilt 1991 · S/N 1162N23PXSum Beech LLC · Ball, LABuilt 1978 · S/N MC-554N23RAMiller James F · Hensley, ARBuilt 1989 · S/N 107N23RBCaldwell Caleb Z · Anchorage, AKBuilt 1956 · S/N 22-4108N23RGRogers Ralph R · Winifred, MTBuilt 1964 · S/N 185-0693N23RHCajun Crimson Air LLC · Hoover, ALS/N 414A0258
Back to AD 2007-04-19 R1