OpenAirDocs.org
AD 2007-04-19 R1

Registered aircraft · 108,428

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.

N1466JLichman Robert P · Florence, SCBuilt 1976 · S/N 466N1466MTabor Shayne · Renville, MNBuilt 1970 · S/N U20601466N1466SCombs Brent L · Dallas, SDBuilt 1976 · S/N 18265013N1466UConcepcion Leonardo · Downey, CAS/N 17267133N1466VGak Flight LLC · Scandia, MNBuilt 1974 · S/N 17263603N1467FJetceo LLC · Kalispell, MTBuilt 1975 · S/N 18502845N1467TThree2tango LLC · Mount Pleasant, SCBuilt 1972 · S/N 28-7205305N14680Hendricks Aric W · Floydada, TXS/N 74-30643N14687Dalessio Enterprises Inc · Smithville, TNS/N 74-30671N1468CBruegman Colt Trustee · Wheatland, WYBuilt 2003 · S/N 0574N1468EMachado Donald C Jr · Honolulu, HIBuilt 2007 · S/N 172S10446N1468MArctic Barnabas Ministries · Kenai, AKBuilt 1970 · S/N U20601468N1468THindle John Charles IV · Whitehouse Station, NJBuilt 1972 · S/N 28R-7235296N1468VMonmouth Flying Club · Monmouth, ILBuilt 1974 · S/N 17263605N14690Davis Scott · Morse, TXBuilt 1973 · S/N 74-30637N14691Weakley Robert Kayce · Pleasant View, TNS/N 74-30682N14695Johnson Charles E · Vernon, TXBuilt 1974 · S/N 74-30688N1469FSkywagon 185 LLC · Ocala, FLBuilt 1975 · S/N 18502847N1469SS & J Farms · Floydada, TXBuilt 1976 · S/N 18265016N1469TThree Wing Flight School LLC · Stratford, CTBuilt 1972 · S/N 28R-7235297N146AAvila Edward V · Saint Johns, AZBuilt 2026 · S/N 90448N146AMGospel Ministries International · Mc Donald, TNBuilt 2013 · S/N 0005918N146AVVidal Aviation LLC · Gaithersburg, MDBuilt 1984 · S/N 28-8590010N146BPNoughton Larry W · Fort Myers, FLBuilt 1994 · S/N CE-1775N146BUSaltwater Aviation LLC · Friday Harbor, WABuilt 1984 · S/N 46-8408057N146CPlanes & Parts Inc · Weston, FLBuilt 1964 · S/N TC-599N146CCRegistered aircraftBuilt 2004 · S/N 9970CCN146CZNiewiarowicz Michael J · Golden, COBuilt 2020 · S/N 1465N146DFMara Taylor D · Mckinney, TXBuilt 2001 · S/N 60344N146EN146e LLC · Thomasville, GABuilt 1982 · S/N 18268292N146FAcrehood Air LLC · St Augustine, FLBuilt 2004 · S/N 18281437N146FCUsda Forest Service Fepp · Malvern, ARBuilt 1966 · S/N P206-0247N146JPMartin John A · Grand Prairie, TXBuilt 2005 · S/N 40.481N146JWDodge Inc · Wilmington, DEBuilt 1976 · S/N 28-7615348N146LWBelvedere Inc · Marion, IABuilt 1979 · S/N 287911236N146MAHong Ted · San Jose, CABuilt 2002 · S/N 903-2002N146MBMlc Flying Club LLC · Saint Peters, MOBuilt 1978 · S/N 32-7840160N146MCGibson William V · Aberdeen, MSS/N 54-73N146MSMagnolia Partners Aviation LLC · Lockesburg, ARBuilt 1984 · S/N 46-8408032N146MWMehling Kevin E · WiesbadenBuilt 1984 · S/N 0389N146PWilliams Mike C · Sonora, TXS/N 24-366N146PSAttitude Aerobatics LLC · Wilmington, DES/N 6061N146PTCoco Aircraft Inc · Merritt Island, FLBuilt 1979 · S/N 28-7916307N146RVLafford Richard M · Dansville, NYBuilt 1995 · S/N 20520N146SJordan Chris H · Reno, NVS/N 146N146SCFantasy Aire Inc · Wilmington, DEBuilt 1968 · S/N 32-985N146SWFairway Systems LLC · New Port Richey, FLBuilt 1980 · S/N 32-8006040N146THanson Brady W · Soldotna, AKBuilt 1952 · S/N 18-2260N146TAShamash Micah I · Larkspur, COBuilt 1980 · S/N EA-176N146TCN146tc LLC · Minneapolis, MNBuilt 2002 · S/N 172S9146
Back to AD 2007-04-19 R1