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.

N567PBNorthbound LLC · Wasilla, AKBuilt 2025 · S/N 14832N567RRGist Aviation LLC · Austin, TXS/N PX1520015N567RSSpitler Robin C · Statesboro, GABuilt 1967 · S/N D-8575N567RVMarini Robert A · Brighton, COBuilt 1991 · S/N 20567-RV6N567SDBordett Jason Scott · Palm Beach Gardens, FLBuilt 1979 · S/N 18267477N567SFCockpit LLC · Melbourne, FLS/N 002N567SHSpitzer Helicopter LLC · Wilmington, DEBuilt 2008 · S/N 1859N567SPAb Prop Plane II LLC · Metairie, LABuilt 2021 · S/N 172S12705N567TB567tb LLC · Rockford, OHBuilt 1999 · S/N 1915N567TCRegistration Pending · Platteville, WIRegistration pending, pending cancellationBuilt 1970 · S/N 39-63N567TXWatts Brian W · Houston, TXBuilt 1974 · S/N 18263069N567UPDodson Robert B · Harvard, ILBuilt 1957 · S/N D-5010N567VEEngbring Jered · Durango, COBuilt 2026 · S/N JE001N567XCovert Tim · Portland, ORBuilt 1962 · S/N 18254115N567ZZulu Aerospace Services LLC · Prescott, AZS/N CE-158N56809Hudak Susanne Marie · Gold Canyon, AZS/N 28-7425041N5680BTveitnes Svein T · Whitewright, TXBuilt 1956 · S/N 33680N5680CSea Spray Aviation LLC · New Smyrna Beach, FLBuilt 1978 · S/N 414A0218N5680JKnutson Wayne R · Thompson, NDBuilt 1970 · S/N 18800630N5680KHarkness Douglas M · Chicago, ILBuilt 1964 · S/N CD-803N5680VTime To Fly LLC · Cleveland, MSBuilt 1977 · S/N 28-7716198N5680WGoines Courtnee J · Jacksonville, FLS/N 28-931N5680YSchildberg Gregory M · Casey, IABuilt 1965 · S/N 18-8292N5681QSteixner Jessica M · Madison, TNBuilt 1965 · S/N 3039N5681SHillcrest Aviation LLC · Midland, TXBuilt 1966 · S/N MA-91N5681VNewell & Sons · Roxboro, NCBuilt 1977 · S/N 28-7790495N56821Cowlin Aviation LLC · Houston, TXBuilt 1973 · S/N 28-7425046N56822Tanner Timothy S · Norton, KSBuilt 1973 · S/N 28R-7435047N56823Fly Tu9 LLC · Vancouver, WABuilt 1973 · S/N 28R-7435048N56828Gillette Daniel R · Chillicothe, ILBuilt 1973 · S/N 28-7425048N5682QNagel Mildred J · Akron, OHS/N 697N5682VSgm Contractors LLC · Great Falls, VABuilt 1977 · S/N 28-7790496N5682WRiggin Flight Service Inc · Madison, SDBuilt 1962 · S/N 28-938N56831Burns Robert A · Fort Myers, FLFirst renewal noticeBuilt 1973 · S/N 28-7415015N56834Maslonka Bradley James · Prior Lake, MNBuilt 1973 · S/N 28R-7435049N56836Spj Aviation Holdings LLC · Bentonville, ARBuilt 1973 · S/N 32-7440030N5683UMccarver Tyler L · Wharton, TXS/N 73-30500N5683WYanta Chris · Rockport, TXBuilt 1962 · S/N 28-940N56847Nepsund Michael L · Park Rapids, MNBuilt 1973 · S/N 28-7415017N56849Macair Aviation LLC · Xenia, OHBuilt 1973 · S/N 28-7415018N5684PAce Drilling LLC · Johnson, KSBuilt 1959 · S/N 24-756N5684WSeverino Racli · Closter, NJBuilt 1963 · S/N 28-948N56853Maxair Complex Flight LLC · Murfreesboro, TNBuilt 1973 · S/N 28R-7435050N5685JAnderson Aerial Spraying Service · Canby, MNBuilt 1970 · S/N 18800635N5685PWalker Richard E · Quanah, TXBuilt 1959 · S/N 24-757N5685SGreen Taylor · Olympia, WABuilt 1966 · S/N MB-125N5685UTres Amigos Flying Club LLC · Redding, CABuilt 1969 · S/N 28-26482N5685WRempel Steven P · Prague, OKBuilt 1962 · S/N 28-953N56860Horst Michael D · Chambersburg, PABuilt 1973 · S/N 28-7415019N56861Wingsleasing LLC · Wichita, KSBuilt 1973 · S/N 28-7405035
Back to AD 2007-04-19 R1