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.

N31JKEquine Associates Inc · Bossier City, LABuilt 1960 · S/N D-6322N31JLGines Roberto · Hypoluxo, FLBuilt 2000 · S/N 23373N31JPOstmeyer John M · Gardner, KSBuilt 1956 · S/N 22-3913N31JSChiles James W · Granbury, TXS/N 20305N31JWMiller Scott A · Granbury, TXBuilt 1973 · S/N 32-7300047N31KDChinook Fibre LLC · Wilmington, DEBuilt 1984 · S/N T30300310N31KEWilcox John B · South Charleston, WVBuilt 1965 · S/N 18256600N31KFSnow Terry R · Oak Harbor, WABuilt 2000 · S/N 607EN31KGMidwest Corporate Air Inc · Bellefontaine, OHBuilt 1978 · S/N 310R1533N31KMMeine William F · Denver, COBuilt 1983 · S/N 7437CN31LDGustte Phil · North Fort Myers, FLBuilt 1973 · S/N 17262736N31LHUp And Up Aviation LLC · Magnolia, TXBuilt 1977 · S/N 28-7816236N31LLNeidert Melvin E · Ulysses, KSBuilt 1993 · S/N MII 1239N31MAlley Shane C · Jackson, MOS/N 188N31MDKarmy Paul Edward · Burleson, TXBuilt 1980 · S/N P21000595N31MJN31mj LLC · Naples, FLBuilt 2020 · S/N 18283118N31MRAllred Don J · Wellington, TXBuilt 1974 · S/N 18262907N31MSWagon Leasing LLC · Jonesboro, ARBuilt 2018 · S/N 593-2018N31NDSchloesser Raymond E · Poland, INS/N 32-654N31PAUtter Joseph Lynn · Springfield, MOBuilt 1967 · S/N MA-132N31PCFlight World Inc · San Juan, PRBuilt 1958 · S/N 23-1349N31PEPhantom Eagle LLC · Hot Springs, VAFirst renewal noticeBuilt 1996 · S/N 14086CN31PGPlacette Jim · Houston, TXBuilt 1977 · S/N 310Q0687N31PLGorum Michael Wren · Red Lodge, MTBuilt 1998 · S/N 18280095N31PPPlyler Aviation Lp · Sherman, TXBuilt 1969 · S/N PP-1N31RKf Lift LLC · Snyder, TXBuilt 1978 · S/N 32R-7885150N31RBTigre Ecossais Aviation Inc Trustee · Wilmington, DEBuilt 1975 · S/N AA5B-0156N31REManley Brian C · Glen Allen, VABuilt 1966 · S/N 32-530N31RTPapuchin LLC · Highwood, ILBuilt 1970 · S/N 414-0158N31RWSpot Air LLC · Burlington, TXBuilt 1977 · S/N 17268693N31SN31s LLC · Wadsworth, OHBuilt 1971 · S/N 28-7205080N31SCObryant Jeffrey A · Fairbanks, AKBuilt 1967 · S/N 79N31SETangent LLC · Phoenix, AZBuilt 2005 · S/N 978-2005N31SGHamilton Enterprises Inc · Reno, NVBuilt 1996 · S/N 377-320-132-18PN31SMWings Over Texas Aviation Inc · Killeen, TXBuilt 1965 · S/N 635N31SRIsaac Timothy S · Independence, ORBuilt 1962 · S/N 18051098N31TAFulltron Aviation LLC · Springfield, MOBuilt 2001 · S/N 6047N31TBRusso Christopher · Huntsville, TXS/N 483N31TDLewis Timothy H · Bristow, VABuilt 2010 · S/N 40059N31TGNaiman Nicholas A · Ramona, CABuilt 1995 · S/N TJ2-8-38GN31THNet Air Co · Monroe, MIBuilt 1979 · S/N AA5B1142N31TJAdams Ian B · Laramie, WYBuilt 2002 · S/N 60414N31TLT M L Aircraft Inc · Narrowsburg, NYS/N 28R-7235314N31TVCornea Kevin Troy · Palm City, FLBuilt 1979 · S/N 27-7954054N31UPGuardian Aero LLC · Flora, ILBuilt 2013 · S/N 2294N31VCVelocity Cruisers LLC · Mabank, TXBuilt 2001 · S/N 3RX015N31VGTita Enterprises LLC · Apex, NCBuilt 2004 · S/N 3551N31VHAmy Inc · Wilmington, DEBuilt 2005 · S/N 3966N31VSJenny Timothy J · Remsen, NYBuilt 1999 · S/N 1273-99N31VTSnediker Daniel G · Pittsburgh, PABuilt 1966 · S/N 28-3208
Back to AD 2007-04-19 R1