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.

N230DMGillespie Flying Services LLC · Trenton, SCBuilt 1997 · S/N 0325N230EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2023 · S/N 172S13092N230EZMeyer Daniel B · Redding, CABuilt 2012 · S/N 462N230FDConnolly Robert · Carmel, NYBuilt 2006 · S/N 1753N230JCN230jc Inc Trustee · Wilmington, DEBuilt 1977 · S/N 27-7854011N230KGAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13468N230MAParker-Omalley Corp · Chatham, NYBuilt 2004 · S/N 953-2004N230PLudian Malgorzata · Bakersfield, CABuilt 1967 · S/N T210-0279N230PKGyger Keith J · Granbury, TXBuilt 1987 · S/N 200-041N230QKuper Carl J II · Dalhart, TXBuilt 1966 · S/N TE-278N230RSAugust Aero LLC · Kalispell, MTS/N 023N230RVEast Tennessee Aviation LLC · Mountain City, TNBuilt 1973 · S/N 17261598N230SAStature Aviation LLC · Addison, TXBuilt 2025 · S/N 172S13435N230SBSierra Bravo Partnership · Liberal, KSBuilt 2011 · S/N 001N230SFWaters Robert · Albuquerque, NMS/N DMO 119N230SUBoelte Aviation LLC · Wilmington, DEBuilt 2026 · S/N 4496639N230SWMartin Co · Tyrone, GABuilt 1971 · S/N 39-37N230TDDickerson Timothy J · Woodlake, CABuilt 2020 · S/N 74551N230UBoard Of Regents · Norman, OKBuilt 2024 · S/N 4496587N230WChandler Charles G · Luray, VABuilt 2003 · S/N 2230N230WCKeiser John T · Santa Fe, NMS/N 010N230XHHowell William J · Portola Valley, CAS/N 28-7425416N23104Atp Aircraft 1 LLC · Wilmington, DEBuilt 2023 · S/N 172S13045N23107Atp Aircraft 1 LLC · Wilmington, DEBuilt 2023 · S/N 172S13105N23108Atp Aircraft 1 LLC · Wilmington, DEBuilt 2023 · S/N 172S13100N2310JRegistration Pending · Aberdeen, SDRegistration pendingBuilt 1963 · S/N M-261N2310QPeterson Kevin · Roseville, CABuilt 1963 · S/N M-374N2310RMccarty Brian Keith · Huntsville, TXBuilt 1964 · S/N 18255410N23110Atp Aircraft 1 LLC · Wilmington, DEBuilt 2023 · S/N 172S13104N23116Atp Aircraft 1 LLC · Wilmington, DEBuilt 2023 · S/N 172S13106N23118Atp Aircraft 1 LLC · Wilmington, DEBuilt 2023 · S/N 172S13107N2311CB & B Aviation LLC · Wayzata, MNBuilt 1953 · S/N 30611N2311FPace Seth M · Malibu, CABuilt 1964 · S/N 21058511N2311GVan Winkle Randy M · Van Buren, MOBuilt 1959 · S/N 51611N2311PCuller Stephen R · Winston Salem, NCBuilt 1955 · S/N 22-2722N2311QHagy Thomas Lee · Abingdon, VABuilt 1963 · S/N M-375N2311TAlanair LLC · Red Hook, NYBuilt 1971 · S/N 28R-7135197N2311VB & L Henry LLC · Chipley, FLBuilt 1997 · S/N E-3111N2311XGoodrich Joshua A · Webster, MNBuilt 1991 · S/N 1972N23120Atp Aircraft 1 LLC · Wilmington, DEBuilt 2023 · S/N 172S13108N23124Atp Aircraft 1 LLC · Wilmington, DEBuilt 2023 · S/N 172S13111N23127Atp Aircraft 1 LLC · Wilmington, DEBuilt 2023 · S/N 172S13112N2312FButler Scotty · Yukon, OKBuilt 1964 · S/N 21058512N2312LSumerau Robert L IV · Lexington, SCBuilt 1963 · S/N M-138N2312NSale Reported · Maize, KSSale reportedBuilt 1991 · S/N 2018N2312PMoran Thomas D · Orchard Park, NYBuilt 1955 · S/N 22-2723N2312QMiller Kevin · Dover, DES/N M-376N2312REagy Gregory L · Boise, IDBuilt 1964 · S/N 18255412N2312XCain James W · Big Rapids, MIBuilt 1965 · S/N 18256212N2312ZDfr LLC · Giltner, NEBuilt 1962 · S/N M-35
Back to AD 2007-04-19 R1