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.

N5419FJfl Aviation LLC · Big Rock, ILBuilt 1976 · S/N 28-7790117N5419NTwallace LLC · Griffin, GABuilt 1980 · S/N 18267702N5419PTrease Marvin R · Elwood, NEBuilt 1958 · S/N 24-473N5419SAberdeen School District · Aberdeen, MSBuilt 1971 · S/N 28-7125117N5419WKenosha Aviation LLC · Jacksonville, FLS/N 0857N541AEHodgson Jerome D · Live Oak, FLBuilt 1996 · S/N 1311N541AMSzmiot Daniel Roy · Marble, COBuilt 2001 · S/N 2153N541BSDalke Debbie R · Aumsville, ORBuilt 1980 · S/N R18201568N541CAVaughan Aviation LLC · Azle, TXBuilt 1976 · S/N 28-7790089N541CDAcheson Wiliam B · Waconia, MNBuilt 2005 · S/N 1491N541CMAero Parts LLC · Roselle, ILS/N 340-0338N541CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 2881050N541DBKing Mark R · Oxnard, CABuilt 1964 · S/N D-7333N541DWJanssen Donald D · Mesa, AZBuilt 1960 · S/N 310-0021N541DZLarson Alexis Kae · Bismarck, NDS/N 92N541ESouthern Illinois University · Murphysboro, ILBuilt 2011 · S/N 17281593N541EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2025 · S/N 172S13311N541FZExtremeaerosports.Com LLC · Corvallis, ORBuilt 2022 · S/N MXS-003N541GW2 Huskies LLC · Sheridan, WYBuilt 2013 · S/N 91659N541HFOpen Flight Plan LLC · Decatur, GABuilt 1973 · S/N 28R-7335335N541JBHuffman Aviation LLC · Burleson, TXBuilt 1981 · S/N R18201752N541JDBlue Sky Flyers LLC · Hoover, ALBuilt 2002 · S/N 0315N541JESimpson Kendal · Port Orange, FLBuilt 1975 · S/N TH-577N541JKKubik James T · Beach City, TXBuilt 1954 · S/N 31166N541JTThomson Jim · Emmett, IDBuilt 1998 · S/N 24884N541KSKent State University · Stow, OHBuilt 2016 · S/N 172S11671N541LCBarbers Point Flight School LLC · Kapolei, HIBuilt 2022 · S/N 172S12860N541PPatch Philip J · Hollis Center, MEBuilt 1997 · S/N 3707N541PCLegacy Staining LLC · Monroe, GAS/N 1563N541PUEquipment Maintenance Specialists LLC · Auxvasse, MOBuilt 2003 · S/N 2844097N541RJSwostar Holdings LLC · Brookhaven, GABuilt 1978 · S/N 28-7911087N541SLCarter Scott P · Dallas, TXBuilt 2009 · S/N 1N541TRegistered aircraftBuilt 2016 · S/N 2207N541WSFox Leasing Group LLC · Hollywood, FLBuilt 2003 · S/N 172S9340N54203Atlanta Aviation Academy Inc · Lawrenceville, GABuilt 1981 · S/N 17274915N54208Swain Brett L · Las Vegas, NVFirst renewal noticeBuilt 1981 · S/N 17274917N5420HChildress Bradley M · Rolling Prairie, INBuilt 1975 · S/N 17265431N5420LHughes Mormon Byrd · Rhome, TXBuilt 1974 · S/N AA5-0510N5420NAdelman Hiram · Bass Harbor, MEBuilt 1980 · S/N 18267703N5420WGade Donald A · Antioch, ILS/N 28-491N54214Halo Aviation Texas LLC · Fredericksburg, TXBuilt 1981 · S/N 17274922N54219Kleb John S · Aurora, ILBuilt 1981 · S/N 17274925N5421DFly First LLC · West Memphis, ARBuilt 1957 · S/N D-4932N5421FAlvey Chad R · Bargersville, INBuilt 1979 · S/N 421C0660N5421JPeruzzi John DBA · Los Angeles, CABuilt 1976 · S/N 340A0108N5421KWings Over Texas Holdings LLC · Denton, TXS/N 17274104N5421LStanfill Michael O · Lucedale, MSS/N AA5-0321N5421SAmeriflyers Of Texas Inc · Addison, TXBuilt 1999 · S/N 172S8080N5421WBrown David A · Olympia, WAFirst renewal noticeBuilt 1962 · S/N 28-492N5422Fitzstephens Erik · North Pole, AKS/N 180-51317
Back to AD 2007-04-19 R1