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.

N56900Roberts Marcus · Vancouver, WAS/N 28-7415023N56902G R Martin & Associates LLC · West Plains, MOS/N 28-7405037N5690CTailwinds Aircraft Holdings LLC · Harrisburg, NEBuilt 1979 · S/N 414A0222N5690DRolfe Cameron R · San Mateo, CABuilt 1978 · S/N 1154N5690KAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 477N5690UPena Flight Partners LLC · Oakland, CABuilt 1970 · S/N 28-26488N5690ZGold Aviation LLC · Greenville, SCBuilt 1990 · S/N TH-1594N56918Virgil Osvaido J · Glendale, AZBuilt 1973 · S/N 28-7415037N5691KRegistration Pending · Shady Shores, TXRegistration pendingBuilt 1964 · S/N D-7619N5691MBrowning Robert F · Washington, DCBuilt 1980 · S/N 485-2N5691PCoady Michael · Taylorville, ILBuilt 1959 · S/N 24-763N5692JSeawings LLC · Holualoa, HIBuilt 1974 · S/N 18263494N5692KBeyer Greg R · Buffalo, MNBuilt 1964 · S/N D-7621N5692QOpen Air Aviation LLC · Colorado Springs, COBuilt 1965 · S/N 702N5692VI N K M & Associates Lllp · Columbia, MOBuilt 1977 · S/N 32R-7780362N5692WFollmer Harvey C III · Trout Run, PABuilt 1963 · S/N 28-1045N5692YSilverado Sales Inc · Orem, UTBuilt 1980 · S/N 494-2N56934Low Allen R · San Francisco, CABuilt 1973 · S/N 32-7400011N56937Qualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 28-7410031N5693KTateshima Satoshi · Los Angeles, CABuilt 1964 · S/N D-7625N5693PBays Aviation LLC · Boerne, TXBuilt 1959 · S/N 24-766N5693QKaufman Ben · Liberty, UTBuilt 1965 · S/N 3045N5693SChupp David · Abbeville, SCBuilt 1966 · S/N MA-94N56942Oracle Aviation LLC · Omaha, NEBuilt 1973 · S/N 28-7410032N56943Mcdowell David M · El Cajon, CABuilt 1973 · S/N 28-7425066N56947Wings Of Hope · Chesterfield, MOBuilt 1973 · S/N 28-7415027N5694AStyer David B · Pendleton, ORBuilt 1980 · S/N 491-2N5694BKrukow Jonathan L · Hampton, IABuilt 1956 · S/N 33694N5694HTischer William D · Shoreview, MNBuilt 1965 · S/N TD-243N5694UPlencner Robert E · Round Lake Beach, ILBuilt 1969 · S/N 28-26491N5694WLange James R · Tempe, AZBuilt 1963 · S/N 28-1060N56950Bodily Kent A · Washington, UTBuilt 1973 · S/N 28-7405038N56957Payne Glenn · Oregon, MOBuilt 1973 · S/N 28-7425070N56958Jackson Michael L · Nixa, MOFirst renewal noticeS/N 28-7425071N5695QBabb Douglas L · Telford, PABuilt 1965 · S/N 3046N5695W95whiskey LLC · Georgetown, MABuilt 1963 · S/N 28-1070N56964Lafollette Larry E · Strafford, MOBuilt 1973 · S/N 28-7405052N56965Brazos River Aviation LLC · Plainview, TXBuilt 1973 · S/N 28-7410036N56966West David A · Astoria, ORBuilt 1973 · S/N 28-7425067N5696BSkyways Group · Albuquerque, NMBuilt 1956 · S/N 33696N5696KLokey Kenneth R · Austin, TXBuilt 1964 · S/N D-7628N5696MHubbard Benjamin L · Quogue, NYBuilt 1980 · S/N 502-2N5696QTrilogy Alliance Group LLC · Kearney, NEBuilt 1965 · S/N 762N5696WGiglio Tom J · South Boston, VABuilt 1963 · S/N 28-1072N56970Simoneau Todd · Sandown, NHS/N 28-7405039N56972Eby Aviation LLC · Duluth, GABuilt 1973 · S/N 28R-7435067N56973Baja Flyers Inc · San Diego, CABuilt 1973 · S/N 28-7410039N56976Tate Bird L Jr · Hammond, NYBuilt 1973 · S/N 28-7425075N56977Evans Holland L · Danielsville, GABuilt 1973 · S/N 28-7425076N56978Brindley James G · Collinsville, ALBuilt 1973 · S/N 28-7425077
Back to AD 2007-04-19 R1