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.

N3434RBurkhardt James · Brookings, SDBuilt 1967 · S/N 18258734N3434SDawsey Carl E · Long Beach, MSBuilt 1964 · S/N 18255834N3434UHale William R · Covina, CABuilt 1963 · S/N 18254834N3434XAronhalt Daniel E · Columbus, INBuilt 1966 · S/N 1126N34358Leap Aviation Inc · Wilmington, DEBuilt 1972 · S/N 17701777N3435EBober Aviation Mountain Flying LLC · Hayesville, NCBuilt 1978 · S/N 17271547N3435FDickens Frank K · Moncure, NCS/N 18257435N3435NBailey Robert B · Damascus, ORBuilt 1967 · S/N 680052N3435UJackson Terry W · Lewisburg, TNBuilt 1963 · S/N 18254835N3435XYeaw Norman E · Hazel Green, ALBuilt 1966 · S/N 670032N3436ARegistered aircraftBuilt 1970 · S/N TE-795N3436FChinik James G · Jacksonville Beach, FLBuilt 1967 · S/N 17700604N3436RGressly Aviation LLC · Camp Verde, AZS/N 28-5680N3436WIsland Aviation Management LLC · Plainview, NYBuilt 1966 · S/N 32-297N3436XWebb Chris · Burns, TNBuilt 1966 · S/N 3403N3436ZRasch Bernard A · Benton City, WABuilt 1960 · S/N 22-7351N34378Johnston Paul · Belleville, MIBuilt 2021 · S/N 47P-129P/130P-P130PN3437FYankee Air LLC · Valdosta, GAS/N 18257437N3437M7550g LLC · Birmingham, MIBuilt 1977 · S/N 28-7890301N3437QJamerson Kendall L · Bovina, TXBuilt 1966 · S/N 320E0037N3437RSmith Darrin M · Torrance, CABuilt 1968 · S/N 18258737N3437TRoberts John M · Mansfield, MOBuilt 1968 · S/N 17700737N3437YLanding Gear Works LLC · Renton, WAS/N 18051937N34380Ackerman Kurt · Kingman, AZBuilt 1960 · S/N 262N34383Crestair Air LLC · Dover, DEBuilt 1961 · S/N 265N34386Jopson Charles M · Etna, CABuilt 1961 · S/N 268N34387Schoenborn Robert F · Folsom, CABuilt 1961 · S/N 269N3438NDurst Luke · Panhandle, TXBuilt 1967 · S/N 680053N3438RDauenhauer Colby · Springtown, TXBuilt 1967 · S/N 18258738N3438SAvco Patrol LLC · Lyndon, KSBuilt 1972 · S/N 17701784N3438UGrau Gary Wayne Jr · Yelm, WABuilt 1963 · S/N 18254838N3438WBlue Wanderers · Fort Wayne, INBuilt 1966 · S/N 32-302N34391Harding Nelson · Lebanon, ORS/N 273N34392Harding Nelson · Lebanon, ORBuilt 1962 · S/N 274N34393Registered aircraftBuilt 1962 · S/N 275N3439SProtsman Bryan D · Anchorage, AKBuilt 1964 · S/N 18255839N3439UFlycatcher Aviation LLC · Purcell, OKBuilt 1963 · S/N 18254839N343ABurleson Steven L · Las Vegas, NVBuilt 2007 · S/N 7224N343AAAnding Paige E · Bryan, TXBuilt 1963 · S/N 18-7947N343ABPonderosa 343 LLC · Richmond, VABuilt 2000 · S/N E-3343N343ACRegistration Pending · Campbellsburg, KYRegistration pendingBuilt 1999 · S/N 404-99N343ASSilberman Allen · West Chester, PABuilt 1992 · S/N WM-2N343BRendzio Robert J · Dothan, ALS/N TD-2N343BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2023 · S/N 2881651N343CDMastin Air LLC · Dover, DEFirst renewal noticeBuilt 2005 · S/N 1343N343CEDeriso Jordan L · Arcadia, FLBuilt 1979 · S/N R18201144N343CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12344N343DBBrown Patrick T Trustee · Osceola, WIBuilt 1957 · S/N BG-317N343DMHess Eric J · Cave Creek, AZBuilt 1996 · S/N 24-3396N343EDKobe Thomas J Jr · Lake Placid, FLBuilt 1967 · S/N 680006
Back to AD 2007-04-19 R1