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.

N442KYSouthern Cubs LLC · Jupiter, FLBuilt 2008 · S/N 12309N442LCKnudtson Kirk · Kasson, MNBuilt 1978 · S/N 28-7890455N442LHSkylane 182q LLC · Punta Gorda, FLBuilt 1980 · S/N 18267692N442MDMagill Zane · Castell, TXBuilt 2007 · S/N 1678N442MLOrlowski Micheal A · Gold Hill, NCBuilt 1966 · S/N 978N442MRSleigh Helicopter LLC · Palm City, FLBuilt 2020 · S/N 30063N442PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 2843498N442PDDesoto Parish Sheriff Office · Mansfield, LABuilt 2003 · S/N 10180N442PMBusby James D II · Port Saint Lucie, FLBuilt 2008 · S/N 40105N442PPWilco Helicopters Inc · Oregon, ILBuilt 2022 · S/N 14569N442PTAutodealersonly.Com Inc · Brunswick, GABuilt 1999 · S/N 30-0018N442PWBeluga LLC · Wasilla, AKBuilt 2002 · S/N 10002N442RAKing Air Properties LLC · Huntington Beach, CABuilt 1971 · S/N 18260739N442RDThompson Helicopters LLC · Uvalde, TXBuilt 2004 · S/N 10237N442RGRivas Andrew · Flagstaff, AZBuilt 1990 · S/N CE-1437N442RJHeymach Robert F · Holbrook, NYBuilt 2007 · S/N MK-0527N442RMRocky Mountain College · Billings, MTBuilt 2013 · S/N 4496347N442RNPope Jim D · Lewiston, IDBuilt 2006 · S/N 11047N442RTRm Capital Holdings LLC · Hockessin, DEBuilt 2026 · S/N 30110N442RWRobertson David · Cullman, ALS/N TE-885N442RYParagon Helicopter Services LLC · Claremore, OKBuilt 2003 · S/N 10096N442SGriffing Flying Service Inc · Port Clinton, OHBuilt 1976 · S/N 770N442SAG & M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 44-7995071N442SDTeam Negrich LLC · Osteen, FLBuilt 2007 · S/N 11625N442SHRudd Wayne G · Basalt, COBuilt 2005 · S/N 10626N442SSN442ss LLC · Middletown, OHBuilt 1965 · S/N P206-0121N442TFerreira James M · Dixon, CABuilt 1998 · S/N 001N442TCCrawford Thomas A · Hawthorne, FLBuilt 2024 · S/N 92219N442THUtah State University · Logan, UTBuilt 2007 · S/N 11619N442TSLehman Aviation LLC · Winamac, INBuilt 2004 · S/N 10414N442TTQualitair LLC Trustee · MichelstadtBuilt 2004 · S/N 1012N442TWMclaws Craig J · Sheridan, WYBuilt 1996 · S/N 001N442VBHicks Seal Coating & Striping LLC · Bell, FLBuilt 2019 · S/N 14296N442WBAllen Lanny D · Indianapolis, INFirst renewal noticeBuilt 1992 · S/N 1916N442WMElkhorn Aviation Inc DBA · Baker City, ORBuilt 2006 · S/N 11555N442WRWhite Ryan R · Polk City, IABuilt 2022 · S/N 90388N44308Hanson Garrett G · Snohomish, WABuilt 1974 · S/N 28-7410093N44309Urstadt Chris M · Girdwood, AKBuilt 1978 · S/N 18503486N4430KLivingston Peter J · Ventura, CABuilt 1948 · S/N NAV-4-1430N4430RDunder Neil DBA · Cicero, INBuilt 1974 · S/N 17263175N4430ULfm Aviation LLC · Bozeman, MTBuilt 1964 · S/N 15060430N4430WMagerit Aviation Inc · South Boston, MABuilt 1974 · S/N D-9609N4430YEvergreen Soaring Inc · Lynnwood, WABuilt 1966 · S/N 25-4056N44314Yates Cecil R · Westminster, CABuilt 1974 · S/N 28-7425403N44318Trinity Air Service Inc · Klamath Falls, ORS/N 28-7415621N4431AResetarits Matthew · West Seneca, NYBuilt 1956 · S/N 22-3760N4431QGraham Huber L · Gulf Breeze, FLBuilt 1973 · S/N 17261710N4431RRaritan Valley Flying School · Princeton, NJBuilt 1974 · S/N 17263176N4431TTaylor Timothy · Chandler, INBuilt 1971 · S/N 28-7125621N4431WUnited Roofing Of Central Florida Inc · Ocala, FLBuilt 1974 · S/N D-9606
Back to AD 2007-04-19 R1