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.

N316NFSteenland Mark R II · Killeen, TXBuilt 1963 · S/N M-473N316PAkin Products Inc · Monticello, ARBuilt 1999 · S/N E-3237N316PABird Acquisition LLC · Phoenix, AZBuilt 2002 · S/N 4496125N316PBDavison David D · Ponte Vedra, FLBuilt 2016 · S/N E-4088N316PHMoon Hill Farm LLC · Kirkland, WABuilt 2004 · S/N 0891N316RALeading Edge Flight Services Inc · Hampshire, ILBuilt 1974 · S/N 310Q1100N316RWFour States Tire & Service Inc · Cortez, COBuilt 1979 · S/N 21063447N316SDHamilton Scott Richard · Fort Worth, TXBuilt 2006 · S/N 23582N316SFDoc Aviation LLC · Ponca City, OKBuilt 1964 · S/N 18255668N316SKKoch Charles S · Prospect, KYBuilt 2009 · S/N 81877N316SMGilland Mark J · Stuarts Draft, VABuilt 2004 · S/N 70065N316STBig Daddys Casinos Inc · Huntington, WVBuilt 2015 · S/N E-4078N316TCEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2008 · S/N 12303N316VUpstate Sc Flyers LLC · West Union, SCBuilt 1979 · S/N 32-7940027N316WVShearer James D · Jacksonville, FLBuilt 2024 · S/N 74847N316XKinney Shawn M · Camp Verde, AZBuilt 1969 · S/N 28R-35670N316ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881641N31700Ratcliff Bruce A · Plain City, OHBuilt 1978 · S/N 32-7840143N31707Bankruptcy Services LLC · Wilmington, DEFirst renewal noticeBuilt 1988 · S/N CE-1287N31708Albatross Air Inc · Beaver, WVS/N EA-486N31709Pace Richard · Leighton, ALS/N 32R-7885121N3170FO'Neill Matthew · Indianapolis, INBuilt 1988 · S/N E-2407N3170QRenfrow Denny · Kelseyville, CABuilt 1967 · S/N 18258170N3170UHarrison Brian C · New London, OHBuilt 1962 · S/N 18254570N3170YStillson John L · Rock Rapids, IAS/N 18254170N3170ZGarrity Frank B · Durham, CABuilt 1959 · S/N 22-7122N3171Derr Matthew R · Frackville, PABuilt 1960 · S/N 39205N31715Brereton Mark C · Lineville, ALBuilt 1978 · S/N 28-7816578N31716Metro Aircraft Co · Bloomington, MNBuilt 1978 · S/N 28-7816579N3171CLand Sea & Air Inc · North Mankato, MNBuilt 1954 · S/N 30970N3171DJohnson Donald B · Lino Lakes, MNBuilt 1955 · S/N 31969N3171EJprg Aviation Inc · Orlando, FLBuilt 1978 · S/N 17271459N3171FRockin Rt LLC · Smithfield, UTS/N 18257271N3171HKh Air LLC · New London, MNBuilt 2018 · S/N 22045CN3171QLynn Aviation LLC · Wilmington, DEBuilt 1977 · S/N 28-7725217N3171TVanlandingham Michael E · Oxnard, CABuilt 1967 · S/N 17700471N3171YDj Aviation LLC · Newburgh, INBuilt 1962 · S/N 18254171N31721Needler Toby · League City, TXS/N 32R-7885124N31724Apostolic Fellowship Assoc · Clearwater, FLBuilt 1978 · S/N 32R-7885126N3172DNorth State Aviators LLC · Cary, NCBuilt 1988 · S/N E-2454N3172EKruchten Larry A · Scottsdale, AZBuilt 1982 · S/N 18268237N3172KAnderson Stephen · Loveland, COBuilt 1988 · S/N E-2435N3172SSterling Flyers LLC · Lehi, UTS/N 18255672N3172YPeters Barry S · Montague, CABuilt 1962 · S/N 18254172N3172ZSpitzer Anthony L · Kalona, IABuilt 1959 · S/N 22-7124N31734Oscar Air LLC · Bethlehem, PABuilt 1978 · S/N 28R-7837246N31736Lees Sea Air · Kiana, AKBuilt 1978 · S/N 32-7840145N31737Scs Construction LLC · Cape May Ch, NJBuilt 1978 · S/N 32-7840146N31739Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1978 · S/N 32R-7885127N3173CMcgaha Justin L · Hooker, OKS/N 30972
Back to AD 2007-04-19 R1